View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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).