Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Asked to save changes although none were made. | Excel Discussion (Misc queries) | |||
This has been asked, but not answered... | Excel Discussion (Misc queries) | |||
On Exit, always asked to save | Excel Worksheet Functions | |||
I bet this has been asked before | Excel Discussion (Misc queries) | |||
Desperate I know I asked before | Excel Discussion (Misc queries) |