I use an Excel worksheet very frequently which always asks quot;Do you want
to save changesquot; when you close it, even when no changes have been made
at all. This is very annoying and does not seem to be connected to my
main Excel setup, as all other Excel worksheets I use on a daily basis
do not give this prompt unless a change has actually been made. The
quot;savequot; option under quot;optionsquot; does not seem responsible, as the setting
in the problematical worksheet is the same as for other worksheets. Is
there any way of resolving this?
Many thanks
TCIf you have any formulas that use the TODAY() or NOW() functions, it will
cause the prompt to show up.
quot;TCquot; wrote:
gt; I use an Excel worksheet very frequently which always asks quot;Do you want
gt; to save changesquot; when you close it, even when no changes have been made
gt; at all. This is very annoying and does not seem to be connected to my
gt; main Excel setup, as all other Excel worksheets I use on a daily basis
gt; do not give this prompt unless a change has actually been made. The
gt; quot;savequot; option under quot;optionsquot; does not seem responsible, as the setting
gt; in the problematical worksheet is the same as for other worksheets. Is
gt; there any way of resolving this?
gt;
gt; Many thanks
gt; TC
gt;
gt;
I'd guess this workbook uses some 'volatile' functions.
support.microsoft.com/kb/274500
--
Jim
quot;TCquot; gt; wrote in message oups.com...
I use an Excel worksheet very frequently which always asks quot;Do you want
to save changesquot; when you close it, even when no changes have been made
at all. This is very annoying and does not seem to be connected to my
main Excel setup, as all other Excel worksheets I use on a daily basis
do not give this prompt unless a change has actually been made. The
quot;savequot; option under quot;optionsquot; does not seem responsible, as the setting
in the problematical worksheet is the same as for other worksheets. Is
there any way of resolving this?
Many thanks
TC
I will suggest you Detect and Repair your MS office. And to do that, point to
help on MS excel standard tool bar then click on DETECT AND REPAIR. Check the
box (discard my customized settings and restore to default). If you are
prompted to insert your MS office CD on your CD-ROM, do so.
I hope this helps.
ObiAkpere
--
quot;I''m illiterate but ready to learn.quot;quot;TCquot; wrote:
gt; I use an Excel worksheet very frequently which always asks quot;Do you want
gt; to save changesquot; when you close it, even when no changes have been made
gt; at all. This is very annoying and does not seem to be connected to my
gt; main Excel setup, as all other Excel worksheets I use on a daily basis
gt; do not give this prompt unless a change has actually been made. The
gt; quot;savequot; option under quot;optionsquot; does not seem responsible, as the setting
gt; in the problematical worksheet is the same as for other worksheets. Is
gt; there any way of resolving this?
gt;
gt; Many thanks
gt; TC
gt;
gt;
to save changesquot; when you close it, even when no changes have been made
at all. This is very annoying and does not seem to be connected to my
main Excel setup, as all other Excel worksheets I use on a daily basis
do not give this prompt unless a change has actually been made. The
quot;savequot; option under quot;optionsquot; does not seem responsible, as the setting
in the problematical worksheet is the same as for other worksheets. Is
there any way of resolving this?
Many thanks
TCIf you have any formulas that use the TODAY() or NOW() functions, it will
cause the prompt to show up.
quot;TCquot; wrote:
gt; I use an Excel worksheet very frequently which always asks quot;Do you want
gt; to save changesquot; when you close it, even when no changes have been made
gt; at all. This is very annoying and does not seem to be connected to my
gt; main Excel setup, as all other Excel worksheets I use on a daily basis
gt; do not give this prompt unless a change has actually been made. The
gt; quot;savequot; option under quot;optionsquot; does not seem responsible, as the setting
gt; in the problematical worksheet is the same as for other worksheets. Is
gt; there any way of resolving this?
gt;
gt; Many thanks
gt; TC
gt;
gt;
I'd guess this workbook uses some 'volatile' functions.
support.microsoft.com/kb/274500
--
Jim
quot;TCquot; gt; wrote in message oups.com...
I use an Excel worksheet very frequently which always asks quot;Do you want
to save changesquot; when you close it, even when no changes have been made
at all. This is very annoying and does not seem to be connected to my
main Excel setup, as all other Excel worksheets I use on a daily basis
do not give this prompt unless a change has actually been made. The
quot;savequot; option under quot;optionsquot; does not seem responsible, as the setting
in the problematical worksheet is the same as for other worksheets. Is
there any way of resolving this?
Many thanks
TC
I will suggest you Detect and Repair your MS office. And to do that, point to
help on MS excel standard tool bar then click on DETECT AND REPAIR. Check the
box (discard my customized settings and restore to default). If you are
prompted to insert your MS office CD on your CD-ROM, do so.
I hope this helps.
ObiAkpere
--
quot;I''m illiterate but ready to learn.quot;quot;TCquot; wrote:
gt; I use an Excel worksheet very frequently which always asks quot;Do you want
gt; to save changesquot; when you close it, even when no changes have been made
gt; at all. This is very annoying and does not seem to be connected to my
gt; main Excel setup, as all other Excel worksheets I use on a daily basis
gt; do not give this prompt unless a change has actually been made. The
gt; quot;savequot; option under quot;optionsquot; does not seem responsible, as the setting
gt; in the problematical worksheet is the same as for other worksheets. Is
gt; there any way of resolving this?
gt;
gt; Many thanks
gt; TC
gt;
gt;
