|
发表于 2014-3-17 01:42:18
|
显示全部楼层
The following applies if there has been an active form in the spreadsheet previously, or a predecessor of the spreadsheet. When an active form is created, by default there is a parameter that calculates the entire workbook when you open it (even if calculation is set to manual). The parameter is stored in excel as a name called "TM1REBUILDOPTION" and by default it equals 1. If you change it to zero then it will no longer recalculate the entire workbook when it is opened. The parameter stays in the spreadsheet even if the active form is deleted, so the only way to tell if it there or not is to go to the name manager.
The spreadsheet will still take 5 minutes to calculate when you press F9 but at least you will have a chance to set the correct parameters for the report first, or you can press shift and F9 to calculate one sheet at a time.
There are a few things that could impact the performance of the report. For example, you could check the "VIEW" formula in each of your sheets because if it has not been set to the correct parameters then the DBRW formulae will retrieve values from the server one cell at a time instead of in batches. |
|