File asks me to save when I haven't changed a thing

  • Thread starter Thread starter GYRO
  • Start date Start date
G

GYRO

Why do some files ask me to save the changes I made when closing them,
when I haven't made any changes whatsoever?
 
Do you have any formulas in your workbook like NOW(), TODAY(), INDIRECT,
OFFSET etc.?

--
Regards,

Peo Sjoblom

(No private emails please)
 
Those functions recalculate when excel recalculates. So the workbook changes
from its original state. That's why you get the prompt.
 
I've also found that if you open a workbook and look at a filter
pull-down list (without selecting any values) then close the workbook
then Excel will think that you have changed something so it will ask if
you want to save.

Pete
 

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

Saving Question 3
Saving in Excel 2010 2
Excel falsely asks me to save! 4
Why am I prompted to save changes I haven't made in Excel 2002? 1
Keeps asking to save. 2
Excel 2007 open file,asks to save changes 0
Excel warns that the file has changed when it hasn't 5
Word 2007 prompts to save unchanged files 4

Back
Top