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
 
You must log in or register to reply here.

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
Excel 2007 open file,asks to save changes 0
Keeps asking to save. 2
Word 2007 prompts to save unchanged files 4
Do you want to save changes to ..... 3

Back
Top