If you avoid Excel names

This page in 2007
Top Previous Next

Opinion is divided between spreadsheet users who value Excel's ability to express formulas in terms of meaningful names, such as =Revenue-Costs, and others who prefer the traditional coordinate notation, such as =D5-D7.

If you don't use names in your own work, in time you will be confronted by a spreadsheet that does make use of them. OAK provides a number of facilities that may help you.

•	You can get a list of all the names in a workbook, so that you can understand what they refer to, using the OAK4 \| Names \| Build Name Database command.

•	You can prepare a map of the workbook, which will show what parts of it have names associated with them, using the OAK4 \| Workbook or Worksheet \| Map command.

•	You can identify some names and have OAK remove mention of them from all or part of a worksheet, restating any formulas that use them are rewritten in conventional spreadsheet coordinate notation with the OAK4 \| Names \| DeApply Names names command.

•	You can identify a formula and have OAK remove mention in it of any names, restating the formula in conventional spreadsheet coordinate notation with the OAK4 \| Formula \| Optimize command.

•	You can get OAK to deliver reports setting out reconstructions of calculations which restate what is going on as simply as possible, without using any names.