![]() |
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. |
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. |
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. |
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. |
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