Worksheet allows you to use multiple versions of the same catalog. This allows you to create some worksheets using the current catalog and other worksheets using older catalogs. You can even put products from different versions of the catalog in one worksheet.
-
Before installing updated catalogs, copy the MFG folder that is to be archived, giving it a unique name at the same time.
-
From the Tools menu select Preferences.
-
Click Content.
-
Beside Select which manufacturers will be available, click
-
Enter a unique 3-character code for the manufacturer.
-
Enter the manufacturer name.
The name will default to the MFG code that was just entered. You can leave this name or type a more detailed name. The value entered in this field will be displayed in the worksheet to indicate if an item is from an archived catalog or from a standard, up-to-date catalog, so be sure to provide a name that will be understood and consistent. -
Now you have to associate a specific folder with the new manufacturer. Select the folder you created in step 1.
In the image above, the copied folder is located next to the other data, in the local Content folder. This is not a requirement. The archived data can be stored at any location accessible to the computer (other local folder, network, etc.). -
With the newly added manufacturer folder selected in the upper section, under Select which content will be available, click
-
Select one or more catalogs (files with .CAT extension) then click Open.
-
Click OK to apply the changes and close the Preferences dialog.
-
Click OK when the two information boxes appear.
Note: that adding catalogs triggers a rebuild of the QuickSearch index. -
For the changes to take effect, exit then reopen 2020 Worksheet.
The manufacturer you just added is now visible in the Explorer bar. It will be located at the bottom of the list.
Note: See Add products from an archived catalog to insert products from this archived catalog to the worksheet.
You can move it up by going into Preferences, Content then using thebutton.