ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Not Automatically Calculating Formulas (https://www.excelbanter.com/excel-worksheet-functions/66268-not-automatically-calculating-formulas.html)

Archie

Not Automatically Calculating Formulas
 
Formulas that have always automatically re calculated formulas no longer do
unless F9 is pressed. Settings are on calculate automatically

Dave Peterson

Not Automatically Calculating Formulas
 
Try selecting all the cells and then:
edit|replace
what: =
with: =
replace all

Maybe it'll wake excel up.

Archie wrote:

Formulas that have always automatically re calculated formulas no longer do
unless F9 is pressed. Settings are on calculate automatically


--

Dave Peterson

Archie

Not Automatically Calculating Formulas
 
The first response didn't work, but made me think, I went to options changed
to Manual under Calculations, re-opened options and changed back to
automatic...this woke up excell...thanks for the push

"Archie" wrote:

Formulas that have always automatically re calculated formulas no longer do
unless F9 is pressed. Settings are on calculate automatically



All times are GMT +1. The time now is 01:39 AM.

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