This feature enables the user to define the same name locally in each worksheet, and set them to values that indicate the purpose of the worksheets.
Charts and dialog sheets do not support names, so this feature applies only to worksheets and macro sheets.
Typical values might include "Input", "Workings" or "Report".
Although things improved a lot with Excel 2007's Name Manager, setting this up can be quite a chore.
OAK's Worksheet Manager makes it very easy. It will do the following:
•List the value of each worksheet's type name alongside the other data.
•Edit the value, either by selection from a drop-down list of existing values, or by entering new ones.
•Locate an existing type name, by presenting a list of candidates.
An Example
Starting with a workbook with 6 worksheets and 4 charts, we see that no type name values are visible.
Clicking the ellipsis button on the Worksheet Manager toolbar yields the "Specify Name for Display" dialog.
This dialog enables the user to specify the name to be displayed, along with the column title.
To select an existing name, click the ellipsis button beside the Name text box. This displays the "Select Name for Display" dialog.
This dialog lists all the local names in the workbook that have constant values. It lists the values the name contains in various sheets, and the number of sheets the name is present in.
In this example, the name "Purpose" is the most likely candidate, considering that it is present in 6 of the 10 sheets (with 4 charts and 6 worksheets, there are only 6 sheets that the name can be in), and the values it has. However, one cannot always rely on an existing type name to be in every worksheet.
Clicking the OK buttons on both this dialog and the previous, the user is returned to the Worksheet Manager, which now shows the type names both in the grid and the drop-down list.
