| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Saving and closing
every time I close it (X out) the worksheet, the blue excel
box pops up asking me if I want to save changes - even if I made none. Other workbooks I can close with out any box popping up when i just look at them. |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Saving and closing
Do you have any volatile formulae in the workbook, such as =TODAY(), =NOW()?
-- __________________________________ HTH Bob "erf" wrote in message ... every time I close it (X out) the worksheet, the blue excel box pops up asking me if I want to save changes - even if I made none. Other workbooks I can close with out any box popping up when i just look at them. |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Saving and closing
Yes, each sheet has it
"Bob Phillips" wrote: Do you have any volatile formulae in the workbook, such as =TODAY(), =NOW()? -- __________________________________ HTH Bob "erf" wrote in message ... every time I close it (X out) the worksheet, the blue excel box pops up asking me if I want to save changes - even if I made none. Other workbooks I can close with out any box popping up when i just look at them. |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Saving and closing
Yes each sheet has it.
"Bob Phillips" wrote: Do you have any volatile formulae in the workbook, such as =TODAY(), =NOW()? -- __________________________________ HTH Bob "erf" wrote in message ... every time I close it (X out) the worksheet, the blue excel box pops up asking me if I want to save changes - even if I made none. Other workbooks I can close with out any box popping up when i just look at them. |
|
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Saving and closing
That is why then, Excel will recalculate those when the workbook is opened,
so it becomes dirty, hence you are asked if you want to save it. -- __________________________________ HTH Bob "erf" wrote in message ... Yes each sheet has it. "Bob Phillips" wrote: Do you have any volatile formulae in the workbook, such as =TODAY(), =NOW()? -- __________________________________ HTH Bob "erf" wrote in message ... every time I close it (X out) the worksheet, the blue excel box pops up asking me if I want to save changes - even if I made none. Other workbooks I can close with out any box popping up when i just look at them. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving and Closing | Excel Discussion (Misc queries) | |||
| Saving when closing excel | Excel Discussion (Misc queries) | |||
| closing & saving | Excel Worksheet Functions | |||
| Is there any way to recover changes after closing w/o saving? | Excel Discussion (Misc queries) | |||
| Closing Excel without saving | Excel Discussion (Misc queries) | |||
Linear Mode
