Question & Answer
Question
Microsoft Excel is set to automatic calculation mode by default. Changing this to manual only lasts for the current session, therefore the next time Excel is launched, the calculation mode is again automatic. Is there a way to set TM1 Perpsectives to always use Excel in manual calculation mode?
Answer
To set Excel to always use manual calculation in Windows 7:
1. Create a new workbook and then go into Excel options.
2. Set Calculation mode to Manual.
3. Save the workbook as "Book.xlsx" and save it in the C:\Users\<USER
PROFILE NAME>\AppData\Roaming\Microsoft\Excel\XLSTART folder.
Each time Excel starts the changes will be made.
This should also perpetuate to new TM1 workbooks.
The same thing can be accomplished by setting up a PERSONAL.xls sheet which contains that
setting, and which can contain any macros that are required to be executed for every new workbook.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21613452