ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Turn off "Do I want to Save" (https://www.excelbanter.com/excel-programming/373463-turn-off-do-i-want-save.html)

Michael Koerner

Turn off "Do I want to Save"
 
Is there a way to turn off the "Do you want to save this file" message if
you have not done any work on the sheet?

--

Regards
Michael Koerner




Paul B

Turn off "Do I want to Save"
 
Michael, sounds like you have some volatile functions in the sheet, they
will re-calculate every time excel is opened, this will make the worksheet
change even if you don't make any changes.

For a list of them have a look here
http://www.decisionmodels.com/calcsecretsi.htm


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Michael Koerner" wrote in message
...
Is there a way to turn off the "Do you want to save this file" message if
you have not done any work on the sheet?

--

Regards
Michael Koerner






Michael Koerner

Turn off "Do I want to Save"
 
Thanks Paul. will check it out.

--

Regards
Michael Koerner


"Paul B" wrote in message
...
Michael, sounds like you have some volatile functions in the sheet, they
will re-calculate every time excel is opened, this will make the worksheet
change even if you don't make any changes.

For a list of them have a look here
http://www.decisionmodels.com/calcsecretsi.htm


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Michael Koerner" wrote in message
...
Is there a way to turn off the "Do you want to save this file" message if
you have not done any work on the sheet?

--

Regards
Michael Koerner









All times are GMT +1. The time now is 11:45 AM.

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