Save Changes?

G

Guest

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
 
C

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel prompts to save when no changes made 2
No "save changes" when exiting Excel 2003 3
Turning off "save changes" prompt 3
Why does Excel ask to Save on Exit? 6
can't find file opened from email,changes made & saved 2
Why does Excel ask to save when no changes were made? 4
Why do certain worksheets ALWAYS ask if I want to save them when closing them? 5
prompt to save when closing file 2

Top