Save changes? even when you've made none

[Donna]

Everytime I close a certain file, it always asks me if I want to save
changes, even though I didn't do anything. I just opened the file, looked
at, then closed it.

 

[Jim Thomlinson]

Best guess is that you have a volatile formula somewhere in the file.
Volatile formulas are formulas like Now(), Rand() or such that recalculate
every time a calcuation runs. So when you open the book, it gets calculated
and even if the volatile function returns the exact same value as it started
with XL is going to think that the file needs to be saved...

 

[Chip Pearson]

Some worksheet functions like NOW() and TODAY() are "volatile" and are
recalculated when the worksheet is opened. Since these values (may)
change, Excel treats the workbook as if it had been changed and
prompts to save the changes.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Donna]

This bulletin board is awesome! Thank you for your help... this is exactly
what I have going on... there is a formula today()...
Thanks again!!