Asked to Save Twice??

M

Mitch Powell

Here's a strnageone. I have a couple of workbooks that when closing after
making changes I get a meesage asking if I want to save changes. I click
yes, the workbook saves and then I get yet another confirmation asking the
same thing.

Not a big deal but curious minds want to know. Any idea why this is
happening? (there is no VBA code attached to the workbooks).
 
B

Bernard Liengme

Your workbook has a volatile function. Try this on a blank workbook:
1) enter the formula =NOW()
2) save the book
3) do something like double clicking one cell, then clicking another
4) now close the workbook; you get a "want to save?" message
While you think you made no changes in step 3, Excel recalculated NOW()
because you went into edit mode.
best wishes
 
M

Mitch Powell

My case if different (we're all different you know). If I close the file
after making changes, it will ask if I want to save changes. I click yes.
At that point I would expect the file to close. But it asks *again* if I
want to save.
 
Top