ExcelBanter - The word "calculate" is at the bottom of my spread sheet. why?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - The word "calculate" is at the bottom of my spread sheet. why? (https://www.excelbanter.com/excel-worksheet-functions/89458-word-calculate-bottom-my-spread-sheet-why.html)

brooks o

The word "calculate" is at the bottom of my spread sheet. why?

How can i fix the model to eliminate the word calculate? I can't find any
errors or circular refererences.

Ron Coderre

The word "calculate" is at the bottom of my spread sheet. why?

Check if your workbook is set to Manual Calculation (which means it will only
recalculate if you press the [F9] key.

From the Excel main menu:
<tools<options<calculation tab
Check: Automatic

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"brooks o" wrote:

How can i fix the model to eliminate the word calculate? I can't find any
errors or circular refererences.

Charles Williams

The word "calculate" is at the bottom of my spread sheet. why?

see http://www.decisionmodels.com/calcsecretsf.htm

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"brooks o" <brooks wrote in message
...
How can i fix the model to eliminate the word calculate? I can't find any
errors or circular refererences.

All times are GMT +1. The time now is 12:52 AM.