Manual / Automatic Calculation
I have a 12MB Excel file (Excel 2003). The file has lots of tabs and lots of
data but few calculations. However, even though I have the option set to "Automatic" the word "Caculate" appears in the status bar at the bottom of the screen. Hitting F9 does not cause anything to happen. Are my formulas calculating in real-time or not? Why is the "Calculate" notification there? |
Manual / Automatic Calculation
maybe...
http://support.microsoft.com/default.aspx?scid=243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References Adam1 Chicago wrote: I have a 12MB Excel file (Excel 2003). The file has lots of tabs and lots of data but few calculations. However, even though I have the option set to "Automatic" the word "Caculate" appears in the status bar at the bottom of the screen. Hitting F9 does not cause anything to happen. Are my formulas calculating in real-time or not? Why is the "Calculate" notification there? -- Dave Peterson |
All times are GMT +1. The time now is 10:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com