LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Values in spreadsheets do not update

Automatic Calculations are on.

"Saruman" wrote:

Go to Tools, Options, Calculation Tab

Make sure that the automatic radio button is highlighted.

OK out of the option screen. Formulas should now auto update.

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------
"Sandy at the Chrome" <Sandy at the wrote
in message ...
When I change or enter values in Excel spreadsheets it does not

automaticaly
compute totals, I have to hit the save button for the spreadsheet to

update
the data.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how 2 spreadsheets in diff locations with auto update confused in uk Excel Discussion (Misc queries) 1 May 12th 06 01:02 PM
Help - Auto update from multiple spreadsheets plngarbage Excel Discussion (Misc queries) 0 May 12th 06 11:05 AM
More problems linking spreadsheets dgg9879 Excel Discussion (Misc queries) 2 April 19th 06 01:00 PM
Update of cell values after insert row? dazman Excel Worksheet Functions 2 August 23rd 05 07:07 AM
Incorrect SUM Values in Excel Spreadsheets Julie Watson Excel Worksheet Functions 2 January 4th 05 01:08 PM


All times are GMT +1. The time now is 04:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"