Revision of Excel/Perspectives Tips from Thu, 2007-02-15 10:09

. to reduce the probability of crashing your Excel, disable Automatic Calculation : Go to Tools->Options-> Calculation Tab then click on the Manual button you can use F9 to manually refresh your spreadsheet

---

. avoid multiple slices on several sheets in a workbook if you can, otherwise Excel becomes quite unstable and some references might get messed up

---

. if you are getting the e10) data directory not found error when loading Perspectives, you need to define the data directory of your local server even if you cannot run one.
Go to Files->Options and enter a valid folder in the Data Directory box. if that box is greyed out then you need to edit manually the variable in your tm1p.ini stored on your PC.

DataBaseDirectory= C:\some\path\

Alternatively you can modify the setting directly from Excel with the following VBA code:
Application.Run("OPTSET", "DatabaseDirectory", "C:\some\path")