Save changes? even when you've made none
 

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.

Save changes? even when you've made none
 

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...
--
HTH...

Jim Thomlinson


"Donna" wrote:

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.

Save changes? even when you've made none
 

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)

On Thu, 20 Nov 2008 13:10:01 -0800, Donna
wrote:

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.

Save changes? even when you've made none
 

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!!

"Chip Pearson" wrote:


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)

On Thu, 20 Nov 2008 13:10:01 -0800, Donna
wrote:

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.