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
|