|
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 like using names, OAK provides a number of facilities that may help you.
| • | You can recover quickly from accidentally filling the name space with unwanted names through mistaken use of Excel's Create Names command, by using the OAK4 | Names | Delete Names in Cells command. |
| • | You can change the scope of a quantity of names added by Excel's Create Names command from global (associated with a workbook) to local (associated with a worksheet) by using the OAK4 | Names | Localize Names in Cells command. |
Though you may like using names, you will sooner or later encounter a client or a partner who does not like the things. OAK provides a number of facilities that may help you.
| • | You can direct him to this free help, which gives lessons in the use of names, so that he may more easily understand your work. |
| • | You can provide a list of all the names in a workbook, so that your counterparty can understand what they refer to, using the OAK4 | Names | Build Name Database command. |
| • | You can provide a map of the workbook, which will show what parts of it have names associated with them, using the OAK4 | Map Workbooks/Worksheet command. |
| • | If all else fails, you can develop a workbook using names, and then strip them out before dispatching the spreadsheet to a name-phobic client or partner, returning the formulas to the coordinate notation widely associated with spreadsheets, using the OAK4 | Names | DeApply Names names command. |
|