ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculate in bottom left hand corner in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/155136-calculate-bottom-left-hand-corner-excel-2007-a.html)

skikat101

Calculate in bottom left hand corner in Excel 2007
 
Recently some of my spreadsheets do not automatically calculate but require
me to hit f9 or click on the word calculate in the bottom left hand quarter.
HOw can I set it back to automaically recalculate?

THanks,

Teethless mama

Calculate in bottom left hand corner in Excel 2007
 
Tools Options Calculation tab select Automatic OK


"skikat101" wrote:

Recently some of my spreadsheets do not automatically calculate but require
me to hit f9 or click on the word calculate in the bottom left hand quarter.
HOw can I set it back to automaically recalculate?

THanks,


Dave Peterson

Calculate in bottom left hand corner in Excel 2007
 
In xl2007, it's under that Office Button and Excel Options (I think--and then my
memory goes completely bad!)

Teethless mama wrote:

Tools Options Calculation tab select Automatic OK

"skikat101" wrote:

Recently some of my spreadsheets do not automatically calculate but require
me to hit f9 or click on the word calculate in the bottom left hand quarter.
HOw can I set it back to automaically recalculate?

THanks,


--

Dave Peterson


All times are GMT +1. The time now is 07:16 AM.

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