Saving and closing

E

erf

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

erf

Yes, each sheet has it

Bob Phillips said:
Do you have any volatile formulae in the workbook, such as =TODAY(), =NOW()?

--
__________________________________
HTH

Bob
Click to expand...
 
E

erf

Yes each sheet has it.

Bob Phillips said:
Do you have any volatile formulae in the workbook, such as =TODAY(), =NOW()?

--
__________________________________
HTH

Bob
Click to expand...
 
B

Bob Phillips

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