Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default System asks to save when no changes made?

Any ideas why, when I open a sheet and don't make changes,
when I go to close the sheet, system asks me if I want to
save. This seem to only happen with some files? Is there a
setting somewhere on the file or the system setting? Any
ideas welcome?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default System asks to save when no changes made?

One possibility is that you have some 'volatile functions' in these
workbooks. Take a look at Charles Williams' WebPage for a listing.

http://www.decisionmodels.com/calcsecretsi.htm

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

Any ideas why, when I open a sheet and don't make changes,
when I go to close the sheet, system asks me if I want to
save. This seem to only happen with some files? Is there a
setting somewhere on the file or the system setting? Any
ideas welcome?

Thanks


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default System asks to save when no changes made?

There could be a =NOW() formula somewhere for the current date, which
will update to today's date, for example. Or they may be an Auto_open
macro running that does something which may not be visible.

"Megan" wrote in message ...
Any ideas why, when I open a sheet and don't make changes,
when I go to close the sheet, system asks me if I want to
save. This seem to only happen with some files? Is there a
setting somewhere on the file or the system setting? Any
ideas welcome?

Thanks

Reply
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
Each time I close an Excel file, it asks if I want to save. Doug Bell Excel Discussion (Misc queries) 4 July 24th 07 07:44 PM
Excel asks to save an unchanged document. Why? kkp Excel Discussion (Misc queries) 9 April 27th 06 08:05 PM
excel 02 always asks "save changes?" when closing unaltered file 6foot6 Excel Discussion (Misc queries) 1 February 16th 06 07:41 PM
why excel 2003 always asks to save or not Dino Hsu Excel Discussion (Misc queries) 2 February 12th 06 12:26 AM
save changes when no changes made Elaine Excel Discussion (Misc queries) 2 January 19th 06 12:55 AM


All times are GMT +1. The time now is 05:11 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"