#1   Report Post  
Sprinks
 
Posts: n/a
Default Save Changes?

Sometimes, but not always, Excel asks if I want to save the current file,
even though I've made no changes. Does anyone know why this occurs, and if
there is a setting I can change to avoid the prompt unless actual changes are
made?

Thank you.
Sprinks
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

There are a number of functions that will update themselves when
the workbook is opened, and this causes Excel to act as though
the workbook has been changed. These functions include NOW() ,
TODAY(), ROW(), etc. See Volatile Functions in help for more
info.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sprinks" wrote in message
...
Sometimes, but not always, Excel asks if I want to save the
current file,
even though I've made no changes. Does anyone know why this
occurs, and if
there is a setting I can change to avoid the prompt unless
actual changes are
made?

Thank you.
Sprinks



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
cannot edit and save jp New Users to Excel 1 February 9th 05 03:25 AM
cannot edit and save jp Excel Worksheet Functions 1 February 9th 05 03:19 AM
cannot edit and save jp Excel Discussion (Misc queries) 0 February 8th 05 03:27 AM
Save & Save As features in file menu of Excel Blue Excel Discussion (Misc queries) 9 December 27th 04 08:49 PM
Missing "Save" and "Save As" functions EMSchon Excel Discussion (Misc queries) 2 December 27th 04 08:01 PM


All times are GMT +1. The time now is 11:43 AM.

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"