ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   "Calculate" note at bottom of my screen? (https://www.excelbanter.com/excel-worksheet-functions/7752-%22calculate%22-note-bottom-my-screen.html)

Shooter

"Calculate" note at bottom of my screen?
 
When in an excel spreadsheet, the bottom of my screen displays:

Ready Calculate Num

The above messages appear at all times. This is the first time I have
noticed the "Calculate" message staying on. Is this normal or could I have a
problem with a formula?
--
Shooter

Frank Kabel

Hi
goto 'tools - Options - Calculate' and enable 'automatic calculation'

--
Regards
Frank Kabel
Frankfurt, Germany

Shooter wrote:
When in an excel spreadsheet, the bottom of my screen displays:

Ready Calculate Num

The above messages appear at all times. This is the first time I have
noticed the "Calculate" message staying on. Is this normal or could I
have a problem with a formula?




JE McGimpsey

"Calculate" is on when Calculation mode (Tools/Options/Calculate) is
Manual.

It also is always on when the number of dependencies (references between
cells) exceeds 65536, so if your workbook is fairly large, that could be
the cause.


In article ,
"Shooter" wrote:

When in an excel spreadsheet, the bottom of my screen displays:

Ready Calculate Num

The above messages appear at all times. This is the first time I have
noticed the "Calculate" message staying on. Is this normal or could I have a
problem with a formula?



All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com