ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Manual / Automatic Calculation (https://www.excelbanter.com/excel-discussion-misc-queries/69850-manual-automatic-calculation.html)

Adam1 Chicago

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?

Dave Peterson

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