Closing Excel without alert
 

I asked this question before but realize I was a little vague in my details.

How can I bypass or disable the warning in Excel 2003 that asks if I want to
"save changes before closing" when in fact I have made no changes. I have NO
formulas in the file that would cause an automatic update.

I did an experiment:
We have a computer with an older version of excel and I opened an excel file
on a shared server, made no changes to the file, and then closed it. No
warning appeared. I came to my computer, (with the new Excel 2003), opened
the same excel file, made no changes, and closed it. Sure enough the warning
alert appeared asking me if I wanted to save changes. This happens on every
single excel file I open. Every one!
I am wondering if it's not something in the way excel opens. Please someone
help.

Closing Excel without alert
 

Didn't you get a notice when you opened that other file on the pc with the newer
version of excel that excel likes to recalculate when opening workbooks that
were saved in older workbooks? (Or words to that effect.)

And if excel is recalculating (for any reason), it'll think that the workbook is
dirty (mark it as having changed since the last save (or when it was opened)).

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

It might work for you.

SLB, accounting wrote:

I asked this question before but realize I was a little vague in my details.

How can I bypass or disable the warning in Excel 2003 that asks if I want to
"save changes before closing" when in fact I have made no changes. I have NO
formulas in the file that would cause an automatic update.

I did an experiment:
We have a computer with an older version of excel and I opened an excel file
on a shared server, made no changes to the file, and then closed it. No
warning appeared. I came to my computer, (with the new Excel 2003), opened
the same excel file, made no changes, and closed it. Sure enough the warning
alert appeared asking me if I wanted to save changes. This happens on every
single excel file I open. Every one!
I am wondering if it's not something in the way excel opens. Please someone
help.

--

Dave Peterson

Closing Excel without alert
 

Excel 2003 notices that a workbook was written in an earlier version of Excel
and asks if you want to re-save in current version.

Is this the message you are getting?

If so, save the workbook once and the message will stop for that workbook.


Gord Dibben MS Excel MVP

On Fri, 1 Sep 2006 12:51:02 -0700, SLB, accounting
wrote:

I asked this question before but realize I was a little vague in my details.

How can I bypass or disable the warning in Excel 2003 that asks if I want to
"save changes before closing" when in fact I have made no changes. I have NO
formulas in the file that would cause an automatic update.

I did an experiment:
We have a computer with an older version of excel and I opened an excel file
on a shared server, made no changes to the file, and then closed it. No
warning appeared. I came to my computer, (with the new Excel 2003), opened
the same excel file, made no changes, and closed it. Sure enough the warning
alert appeared asking me if I wanted to save changes. This happens on every
single excel file I open. Every one!
I am wondering if it's not something in the way excel opens. Please someone
help.

Closing Excel without alert
 

Is there an addin on your machine with 2003 that could be doing something to
your files, or possibly something in your personal workbook?
--
HTH...

Jim Thomlinson


"SLB, accounting" wrote:

I asked this question before but realize I was a little vague in my details.

How can I bypass or disable the warning in Excel 2003 that asks if I want to
"save changes before closing" when in fact I have made no changes. I have NO
formulas in the file that would cause an automatic update.

I did an experiment:
We have a computer with an older version of excel and I opened an excel file
on a shared server, made no changes to the file, and then closed it. No
warning appeared. I came to my computer, (with the new Excel 2003), opened
the same excel file, made no changes, and closed it. Sure enough the warning
alert appeared asking me if I wanted to save changes. This happens on every
single excel file I open. Every one!
I am wondering if it's not something in the way excel opens. Please someone
help.

Closing Excel without alert
 

I thought it could be that also, so I created a new spreadsheet to test it,
and no, it still asks if I want to save changes. I will check Mr.
Thomlinson's question about a possible addin. Other than that, I am at a
loss. It's not affecting how excel runs, it's just annoying. Thanks for the
response.

"Gord Dibben" wrote:

Excel 2003 notices that a workbook was written in an earlier version of Excel
and asks if you want to re-save in current version.

Is this the message you are getting?

If so, save the workbook once and the message will stop for that workbook.


Gord Dibben MS Excel MVP

On Fri, 1 Sep 2006 12:51:02 -0700, SLB, accounting
wrote:

I asked this question before but realize I was a little vague in my details.

How can I bypass or disable the warning in Excel 2003 that asks if I want to
"save changes before closing" when in fact I have made no changes. I have NO
formulas in the file that would cause an automatic update.

I did an experiment:
We have a computer with an older version of excel and I opened an excel file
on a shared server, made no changes to the file, and then closed it. No
warning appeared. I came to my computer, (with the new Excel 2003), opened
the same excel file, made no changes, and closed it. Sure enough the warning
alert appeared asking me if I wanted to save changes. This happens on every
single excel file I open. Every one!
I am wondering if it's not something in the way excel opens. Please someone
help.

Closing Excel without alert
 

Thanks for your response. I will check on this possibility, although I'm not
sure if I know what to look for in addin properties.

"Jim Thomlinson" wrote:

Is there an addin on your machine with 2003 that could be doing something to
your files, or possibly something in your personal workbook?
--
HTH...

Jim Thomlinson


"SLB, accounting" wrote:

I asked this question before but realize I was a little vague in my details.

How can I bypass or disable the warning in Excel 2003 that asks if I want to
"save changes before closing" when in fact I have made no changes. I have NO
formulas in the file that would cause an automatic update.

I did an experiment:
We have a computer with an older version of excel and I opened an excel file
on a shared server, made no changes to the file, and then closed it. No
warning appeared. I came to my computer, (with the new Excel 2003), opened
the same excel file, made no changes, and closed it. Sure enough the warning
alert appeared asking me if I wanted to save changes. This happens on every
single excel file I open. Every one!
I am wondering if it's not something in the way excel opens. Please someone
help.