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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Saving and Closing 2
Excel Providing user message when RED X clicked & properly closing application. 2
Excel VBA - Problem with Closing Print Preview 0
Closing excel application without closing all workbooks at the sa. 2
Disable save/saveas dialog box upon closing 11
Cannot save design changes in table/report in Access 2007 3
Closing form without saving changes 4
Excel Saving 1

Top