ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Saving and closing (https://www.excelbanter.com/setting-up-configuration-excel/191638-saving-closing.html)

erf

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.

Bob Phillips[_3_]

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.




erf

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.





erf

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.





Bob Phillips[_3_]

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.








All times are GMT +1. The time now is 04:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com