Asked to Save Twice??

  • Thread starter Thread starter Mitch Powell
  • Start date Start date
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).
 
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
 
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.
 
Back
Top