Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ?
It occurs very often that I open an Excel sheet and do not change anything in that sheet.
Then (after viewing some content) I want close it again. But a message dialog pops up asking me if I want to save the changes. I guess that this is the result of embedded macros. However this is not intuitive and not user friendly. How do I avoid these kind of popups when no changes took place ? Markus |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ?
This is probably caused =by having volatile worksheet functions, such as
=TODAY(). You could get around it, but it could stop it being saved when it should, so I would just live with it. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Markus Obermayer" wrote in message ... It occurs very often that I open an Excel sheet and do not change anything in that sheet. Then (after viewing some content) I want close it again. But a message dialog pops up asking me if I want to save the changes. I guess that this is the result of embedded macros. However this is not intuitive and not user friendly. How do I avoid these kind of popups when no changes took place ? Markus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot close Excel - getting "Do you want to save the changes in solver.xla" | Excel Discussion (Misc queries) | |||
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Discussion (Misc queries) | |||
Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Worksheet Functions | |||
Suppress "Disable/Enable Macros" and Query Refresh dialog on open | Excel Programming | |||
How can I get "File Close" to prompt me to "Save Changes" ?? | Excel Programming |