Thread: Save Changes?
View Single Post
  #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