Saving and closing

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

 

[Bob Phillips]

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

 

[erf]

Yes, each sheet has it

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

--
__________________________________
HTH

Bob

 

[erf]

Yes each sheet has it.

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

--
__________________________________
HTH

Bob

 

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