Diff for Excel/Perspectives Tips
| Thu, 2007-02-15 10:09 by admin | Tue, 2008-10-28 14:52 by admin | ||
|---|---|---|---|
| < previous diff | next diff > | ||
| Changes to Body | |||
| Line 1 | Line 1 | ||
| - | <p>. to reduce the probability of crashing your Excel, <strong>disable Automatic Calculation</strong> : Go to Tools->Options-> Calculation Tab then click on the Manual button you can use F9 to manually refresh your spreadsheet<hr /> . <strong>avoid multiple slices</strong> on several sheets in a workbook if you can, otherwise Excel becomes quite unstable and some references might get messed up <hr />. if you are getting the <strong>e10) data directory not found</strong> error when loading Perspectives, you need to define the data directory of your local server even if you cannot run one.<br>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.</p><p> DataBaseDirectory= C:\some\path\</p> | + | <p>. to reduce the probability of crashing your Excel, <strong>disable Automatic Calculation</strong> : Go to Tools->Options-> Calculation Tab then click on the Manual button |
| + | You can use: | ||
| + | <strong>F9</strong> to manually refresh all the open workbooks | ||
| + | <strong>Shift F9</strong> to refresh only the current worksheet | ||
| + | <strong>F2 enter</strong> (edit cell) to refresh only 1 cell | ||
| + | <hr /> . <strong>avoid multiple dynamic slices</strong> on several sheets in a workbook if you can, otherwise Excel becomes quite unstable and some references might get messed up <hr />. if you are getting the <strong>e10) data directory not found</strong> error when loading Perspectives, you need to define the data directory of your local server even if you cannot run one.<br>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.</p><p> DataBaseDirectory= C:\some\path\</p> | ||
| <p>Alternatively you can modify the setting directly from Excel with the following VBA code:<br>Application.Run("OPTSET", "DatabaseDirectory", "C:\some\path")</p> | <p>Alternatively you can modify the setting directly from Excel with the following VBA code:<br>Application.Run("OPTSET", "DatabaseDirectory", "C:\some\path")</p> | ||
Revision of Tue, 2008-10-28 14:52:
Excel/Perspectives Tips
. 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 all the open workbooks
Shift F9 to refresh only the current worksheet
F2 enter (edit cell) to refresh only 1 cell
. avoid multiple dynamic 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")
