LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default after saving excel 2003 file, functions do not update anymore

When I open Excel and make a SUM of several cells, the SUM is displayed and
calculated correctly. If I save the file and re-open it and change any value
of one of the cells in the SULM, the result stays the same, the SUM is not
recalculated. If I create a new SUM in this Excel file, the result returns
ZERO. Calculation is set to AUTOMATIC, F9 does not change this.
 
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
Saving Excel (2003) File Causes Growing Size [email protected] Excel Discussion (Misc queries) 1 December 13th 06 11:47 AM
editing an excel 97 file within excel 2003 and saving back as exce Chris Egebrecht Excel Discussion (Misc queries) 3 March 24th 06 11:14 PM
excel 2003 saving a file clb Excel Discussion (Misc queries) 0 February 13th 06 03:13 PM
Saving Excel 2003 file in .txt format mikejfox99 Excel Discussion (Misc queries) 2 August 5th 05 05:12 PM
Excel 2003: File->Close without saving changes (save menu does no. Wai-Yee Excel Discussion (Misc queries) 5 July 25th 05 11:49 PM


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

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

About Us

"It's about Microsoft Excel"