ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formulas aren't updating (https://www.excelbanter.com/excel-worksheet-functions/144224-formulas-arent-updating.html)

ANTHER

Formulas aren't updating
 
Hi have been working in a spreadsheet for a couple months now and today I
went in and updated some values but the sum totals aren't reflecting my
changes nor does the =C20 capture what I have updated in that cell. Any tips?

Max

Formulas aren't updating
 
Perhaps calc mode is at Manual ?

To check/change:
Click Tools Options Calculation tab
Ensure "Automatic" is checked OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ANTHER" wrote:
Hi have been working in a spreadsheet for a couple months now and today I
went in and updated some values but the sum totals aren't reflecting my
changes nor does the =C20 capture what I have updated in that cell. Any tips?


Stan Brown

Formulas aren't updating
 
Sat, 26 May 2007 07:57:00 -0700 from ANTHER
:
Hi have been working in a spreadsheet for a couple months now and today I
went in and updated some values but the sum totals aren't reflecting my
changes nor does the =C20 capture what I have updated in that cell. Any tips?


Tools | Options | Calculation | Automatic

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/


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

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