Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like to suggest that the calculation setting in Excel is changed so
that rather than being an application level setting it becomes a workbook level setting. ie a user could have several workbooks open, each with different calculation settings (automatic, manual, etc). When a workbook is saved and closed the most recent calculation setting would be remembered by excel. This request stems from the following problem: 1. Lets say I have a small workbook (even a blank workbook) open with calculation set to automatic. 2. Next I open a large workbook which runs a VBA procedure upon opening. Part of that procedure is to set the calculation to manual because the model is too big to leave it on automatic. 3. However, because of the 1st model being open the 2nd model wants to perform a full recalculation before running the auto_open code. 4. This makes the 2nd model appear to be VERY slow and I usually interupt the calculation by, say, pressing CAPS LOCK which then allows the auto_open procedure to run. 5. Pressing CAPS LOCK works for me because I know to do that now but when other users (who are not so experienced with Excel) use my model they don't know to do this, so they end up with the view that the model is slow to open which is inaccurate. Another way of achieving this would simply be to allow auto_open macros to run before a full recalculation is performed upon opening a model. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I set the order of calculation of Data Tables in Excel? | Excel Worksheet Functions | |||
Is there a standard deviation calculation in Excel? | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
time calculation excel | Excel Worksheet Functions |