Asked to Save Twice??
 

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

Asked to Save Twice??
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mitch Powell" wrote in message
...
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).

Asked to Save Twice??
 

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.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mitch Powell" wrote in message
...
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).