I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on the
cell ... I don't pull the list down or choose any data. Excel is acting as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ... that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation settings.
Do you want to extend data validation to these cells?" I answer "yes," and
the form comes up fine, with the proper data validation. But could this have
something to do with the erroneous exit message?

Do you have any of these volatile functions in your workbook?

=AREAS()
=INDEX()
=OFFSET()
=CELL()
=INDIRECT()
=ROWS()
=COLUMNS()
=NOW()
=TODAY()
=RAND()

These evaluate with each calculation. And cause excel to think your workbook
has changed.

And excel likes to recalculate workbooks created in earlier versions. Is this
the case in your situation?

Do you have any macros that run automatically that could be changing something?



crimsonkng wrote:

I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on the
cell ... I don't pull the list down or choose any data. Excel is acting as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ... that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation settings.
Do you want to extend data validation to these cells?" I answer "yes," and
the form comes up fine, with the proper data validation. But could this have
something to do with the erroneous exit message?

--

Dave Peterson

Actually, this usually occurs when you have cells that contain formulas like
=NOW() or =TODAY()
:) These formulas always update on open.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"crimsonkng" wrote in message
...
I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change
any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on
the
cell ... I don't pull the list down or choose any data. Excel is acting
as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ...
that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation
settings.
Do you want to extend data validation to these cells?" I answer "yes,"
and
the form comes up fine, with the proper data validation. But could this
have
something to do with the erroneous exit message?

Here's a snippet from a Google archives search:

Hi Sal:
If you have certain worksheet functions in your workbook (examples are
TODAY, NOW, OFFSET), they will be recalculated and even if there is no
change, Excel will present the Save Changes dialog.
....
Vasant

hth,

Doug

"crimsonkng" wrote in message
...
I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change
any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on
the
cell ... I don't pull the list down or choose any data. Excel is acting
as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ...
that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation
settings.
Do you want to extend data validation to these cells?" I answer "yes,"
and
the form comes up fine, with the proper data validation. But could this
have
something to do with the erroneous exit message?

To Dave, Anne, and Doug:

Thank you for your suggestions but, unfortunately, none of those are the case.

I went back to an earlier version of my spreadsheet, when I had only ONE
cell in which there was data validation (as opposed to my currrent
spreadsheet in which there are dozens of pick-list cells), and discovered
that this message appears ONLY when I pass my highlight over that one cell.
It's really wierd. I can move around the entire spreadsheet (about 300 rows
and 10 columns) but I get the "save changes?" message ONLY when my highlight
passes over the data-validation field. It's really bizarre.

Dan


"crimsonkng" wrote:

I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on the
cell ... I don't pull the list down or choose any data. Excel is acting as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ... that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation settings.
Do you want to extend data validation to these cells?" I answer "yes," and
the form comes up fine, with the proper data validation. But could this have
something to do with the erroneous exit message?

Do you have any macros in that workbook? Maybe an event is firing that makes
excel think the workbook has been changed.

try opening excel in safe mode.
close excel
windows start button|Run
excel /safe

file|Open your workbook

Do you get the same prompt when you do the same stuff?

===
And with data validation, you only get that message when you select the cell,
right--not just mousing over the cell?

crimsonkng wrote:

To Dave, Anne, and Doug:

Thank you for your suggestions but, unfortunately, none of those are the case.

I went back to an earlier version of my spreadsheet, when I had only ONE
cell in which there was data validation (as opposed to my currrent
spreadsheet in which there are dozens of pick-list cells), and discovered
that this message appears ONLY when I pass my highlight over that one cell.
It's really wierd. I can move around the entire spreadsheet (about 300 rows
and 10 columns) but I get the "save changes?" message ONLY when my highlight
passes over the data-validation field. It's really bizarre.

Dan

"crimsonkng" wrote:

I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on the
cell ... I don't pull the list down or choose any data. Excel is acting as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ... that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation settings.
Do you want to extend data validation to these cells?" I answer "yes," and
the form comes up fine, with the proper data validation. But could this have
something to do with the erroneous exit message?

--

Dave Peterson

Yes, Dave, there's a 6,000-line macro. But it doesn't run automatically. (I
even "disabled macros" when I opened the file and I still got the erroneous
save message.)

I opened Excel in Safe mode and, yes, I still got that message when I merely
passed over the specific cell (H6) that has the data-validation.

All I can think is that there are lots of other cells that are dependent
upon H6. I guess Excel treats that (kind of) cell differently? I don't
know. It's just really wierd. I don't change anything in H6. I don't even
click it. I just move the cell highlight over it/past it. Maybe it's
because so many other cells are dependent upon the value in that cell.

Or maybe I merely found a bug in Excel?




"Dave Peterson" wrote:

Do you have any macros in that workbook? Maybe an event is firing that makes
excel think the workbook has been changed.

try opening excel in safe mode.
close excel
windows start button|Run
excel /safe

file|Open your workbook

Do you get the same prompt when you do the same stuff?

===
And with data validation, you only get that message when you select the cell,
right--not just mousing over the cell?

crimsonkng wrote:

To Dave, Anne, and Doug:

Thank you for your suggestions but, unfortunately, none of those are the case.

I went back to an earlier version of my spreadsheet, when I had only ONE
cell in which there was data validation (as opposed to my currrent
spreadsheet in which there are dozens of pick-list cells), and discovered
that this message appears ONLY when I pass my highlight over that one cell.
It's really wierd. I can move around the entire spreadsheet (about 300 rows
and 10 columns) but I get the "save changes?" message ONLY when my highlight
passes over the data-validation field. It's really bizarre.

Dan

"crimsonkng" wrote:

I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on the
cell ... I don't pull the list down or choose any data. Excel is acting as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ... that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation settings.
Do you want to extend data validation to these cells?" I answer "yes," and
the form comes up fine, with the proper data validation. But could this have
something to do with the erroneous exit message?

--

Dave Peterson

I couldn't reproduce this in xl2003. What version of excel are you running?

(Maybe someone can test it and post back their results.)

crimsonkng wrote:

Yes, Dave, there's a 6,000-line macro. But it doesn't run automatically. (I
even "disabled macros" when I opened the file and I still got the erroneous
save message.)

I opened Excel in Safe mode and, yes, I still got that message when I merely
passed over the specific cell (H6) that has the data-validation.

All I can think is that there are lots of other cells that are dependent
upon H6. I guess Excel treats that (kind of) cell differently? I don't
know. It's just really wierd. I don't change anything in H6. I don't even
click it. I just move the cell highlight over it/past it. Maybe it's
because so many other cells are dependent upon the value in that cell.

Or maybe I merely found a bug in Excel?

"Dave Peterson" wrote:

Do you have any macros in that workbook? Maybe an event is firing that makes
excel think the workbook has been changed.

try opening excel in safe mode.
close excel
windows start button|Run
excel /safe

file|Open your workbook

Do you get the same prompt when you do the same stuff?

===
And with data validation, you only get that message when you select the cell,
right--not just mousing over the cell?

crimsonkng wrote:

To Dave, Anne, and Doug:

Thank you for your suggestions but, unfortunately, none of those are the case.

I went back to an earlier version of my spreadsheet, when I had only ONE
cell in which there was data validation (as opposed to my currrent
spreadsheet in which there are dozens of pick-list cells), and discovered
that this message appears ONLY when I pass my highlight over that one cell.
It's really wierd. I can move around the entire spreadsheet (about 300 rows
and 10 columns) but I get the "save changes?" message ONLY when my highlight
passes over the data-validation field. It's really bizarre.

Dan

"crimsonkng" wrote:

I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on the
cell ... I don't pull the list down or choose any data. Excel is acting as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ... that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation settings.
Do you want to extend data validation to these cells?" I answer "yes," and
the form comes up fine, with the proper data validation. But could this have
something to do with the erroneous exit message?

--

Dave Peterson


--

Dave Peterson

2000.

I wonder if that's the problem. Maybe I should upgrade.

I don't suppose that I could send the spreadsheet to you ... and have you
take a look? (I know that's asking a lot.)

You could disable the macro ... the problem still exists even if you disable
the macro.

Thanks for the responses/attempts.



"Dave Peterson" wrote:

I couldn't reproduce this in xl2003. What version of excel are you running?

(Maybe someone can test it and post back their results.)

crimsonkng wrote:

Yes, Dave, there's a 6,000-line macro. But it doesn't run automatically. (I
even "disabled macros" when I opened the file and I still got the erroneous
save message.)

I opened Excel in Safe mode and, yes, I still got that message when I merely
passed over the specific cell (H6) that has the data-validation.

All I can think is that there are lots of other cells that are dependent
upon H6. I guess Excel treats that (kind of) cell differently? I don't
know. It's just really wierd. I don't change anything in H6. I don't even
click it. I just move the cell highlight over it/past it. Maybe it's
because so many other cells are dependent upon the value in that cell.

Or maybe I merely found a bug in Excel?

"Dave Peterson" wrote:

Do you have any macros in that workbook? Maybe an event is firing that makes
excel think the workbook has been changed.

try opening excel in safe mode.
close excel
windows start button|Run
excel /safe

file|Open your workbook

Do you get the same prompt when you do the same stuff?

===
And with data validation, you only get that message when you select the cell,
right--not just mousing over the cell?

crimsonkng wrote:

To Dave, Anne, and Doug:

Thank you for your suggestions but, unfortunately, none of those are the case.

I went back to an earlier version of my spreadsheet, when I had only ONE
cell in which there was data validation (as opposed to my currrent
spreadsheet in which there are dozens of pick-list cells), and discovered
that this message appears ONLY when I pass my highlight over that one cell.
It's really wierd. I can move around the entire spreadsheet (about 300 rows
and 10 columns) but I get the "save changes?" message ONLY when my highlight
passes over the data-validation field. It's really bizarre.

Dan

"crimsonkng" wrote:

I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on the
cell ... I don't pull the list down or choose any data. Excel is acting as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ... that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation settings.
Do you want to extend data validation to these cells?" I answer "yes," and
the form comes up fine, with the proper data validation. But could this have
something to do with the erroneous exit message?

--

Dave Peterson


--

Dave Peterson

I just checked it on a 2003 machine and it happens in that version, too.
Dan


"crimsonkng" wrote:

2000.

I wonder if that's the problem. Maybe I should upgrade.

I don't suppose that I could send the spreadsheet to you ... and have you
take a look? (I know that's asking a lot.)

You could disable the macro ... the problem still exists even if you disable
the macro.

Thanks for the responses/attempts.



"Dave Peterson" wrote:

I couldn't reproduce this in xl2003. What version of excel are you running?

(Maybe someone can test it and post back their results.)

crimsonkng wrote:

Yes, Dave, there's a 6,000-line macro. But it doesn't run automatically. (I
even "disabled macros" when I opened the file and I still got the erroneous
save message.)

I opened Excel in Safe mode and, yes, I still got that message when I merely
passed over the specific cell (H6) that has the data-validation.

All I can think is that there are lots of other cells that are dependent
upon H6. I guess Excel treats that (kind of) cell differently? I don't
know. It's just really wierd. I don't change anything in H6. I don't even
click it. I just move the cell highlight over it/past it. Maybe it's
because so many other cells are dependent upon the value in that cell.

Or maybe I merely found a bug in Excel?

"Dave Peterson" wrote:

Do you have any macros in that workbook? Maybe an event is firing that makes
excel think the workbook has been changed.

try opening excel in safe mode.
close excel
windows start button|Run
excel /safe

file|Open your workbook

Do you get the same prompt when you do the same stuff?

===
And with data validation, you only get that message when you select the cell,
right--not just mousing over the cell?

crimsonkng wrote:

To Dave, Anne, and Doug:

Thank you for your suggestions but, unfortunately, none of those are the case.

I went back to an earlier version of my spreadsheet, when I had only ONE
cell in which there was data validation (as opposed to my currrent
spreadsheet in which there are dozens of pick-list cells), and discovered
that this message appears ONLY when I pass my highlight over that one cell.
It's really wierd. I can move around the entire spreadsheet (about 300 rows
and 10 columns) but I get the "save changes?" message ONLY when my highlight
passes over the data-validation field. It's really bizarre.

Dan

"crimsonkng" wrote:

I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on the
cell ... I don't pull the list down or choose any data. Excel is acting as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ... that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation settings.
Do you want to extend data validation to these cells?" I answer "yes," and
the form comes up fine, with the proper data validation. But could this have
something to do with the erroneous exit message?

--

Dave Peterson


--

Dave Peterson

How big is the file after you zip it?

If it's pretty small (less than 250K), go ahead.

(I don't like opening unknown files and I don't like downloading large
attachments.)

crimsonkng wrote:

2000.

I wonder if that's the problem. Maybe I should upgrade.

I don't suppose that I could send the spreadsheet to you ... and have you
take a look? (I know that's asking a lot.)

You could disable the macro ... the problem still exists even if you disable
the macro.

Thanks for the responses/attempts.

"Dave Peterson" wrote:

I couldn't reproduce this in xl2003. What version of excel are you running?

(Maybe someone can test it and post back their results.)

crimsonkng wrote:

Yes, Dave, there's a 6,000-line macro. But it doesn't run automatically. (I
even "disabled macros" when I opened the file and I still got the erroneous
save message.)

I opened Excel in Safe mode and, yes, I still got that message when I merely
passed over the specific cell (H6) that has the data-validation.

All I can think is that there are lots of other cells that are dependent
upon H6. I guess Excel treats that (kind of) cell differently? I don't
know. It's just really wierd. I don't change anything in H6. I don't even
click it. I just move the cell highlight over it/past it. Maybe it's
because so many other cells are dependent upon the value in that cell.

Or maybe I merely found a bug in Excel?

"Dave Peterson" wrote:

Do you have any macros in that workbook? Maybe an event is firing that makes
excel think the workbook has been changed.

try opening excel in safe mode.
close excel
windows start button|Run
excel /safe

file|Open your workbook

Do you get the same prompt when you do the same stuff?

===
And with data validation, you only get that message when you select the cell,
right--not just mousing over the cell?

crimsonkng wrote:

To Dave, Anne, and Doug:

Thank you for your suggestions but, unfortunately, none of those are the case.

I went back to an earlier version of my spreadsheet, when I had only ONE
cell in which there was data validation (as opposed to my currrent
spreadsheet in which there are dozens of pick-list cells), and discovered
that this message appears ONLY when I pass my highlight over that one cell.
It's really wierd. I can move around the entire spreadsheet (about 300 rows
and 10 columns) but I get the "save changes?" message ONLY when my highlight
passes over the data-validation field. It's really bizarre.

Dan

"crimsonkng" wrote:

I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on the
cell ... I don't pull the list down or choose any data. Excel is acting as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ... that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation settings.
Do you want to extend data validation to these cells?" I answer "yes," and
the form comes up fine, with the proper data validation. But could this have
something to do with the erroneous exit message?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Wow, Dave, yer a pal.

I removed all the macros so, zipped, it's down to 128KB. (Unzipped, it's
580KB.)

I know that it's a lot for me to ask you to look at it but if you really
don't mind, you can send your email address to me at and
then I'll send the file to you. (or how else should I send it to you? ... I
don't see your email address in any of the replies)

Dan

"Dave Peterson" wrote:

How big is the file after you zip it?

If it's pretty small (less than 250K), go ahead.

(I don't like opening unknown files and I don't like downloading large
attachments.)

crimsonkng wrote:

2000.

I wonder if that's the problem. Maybe I should upgrade.

I don't suppose that I could send the spreadsheet to you ... and have you
take a look? (I know that's asking a lot.)

You could disable the macro ... the problem still exists even if you disable
the macro.

Thanks for the responses/attempts.

"Dave Peterson" wrote:

I couldn't reproduce this in xl2003. What version of excel are you running?

(Maybe someone can test it and post back their results.)

crimsonkng wrote:

Yes, Dave, there's a 6,000-line macro. But it doesn't run automatically. (I
even "disabled macros" when I opened the file and I still got the erroneous
save message.)

I opened Excel in Safe mode and, yes, I still got that message when I merely
passed over the specific cell (H6) that has the data-validation.

All I can think is that there are lots of other cells that are dependent
upon H6. I guess Excel treats that (kind of) cell differently? I don't
know. It's just really wierd. I don't change anything in H6. I don't even
click it. I just move the cell highlight over it/past it. Maybe it's
because so many other cells are dependent upon the value in that cell.

Or maybe I merely found a bug in Excel?

"Dave Peterson" wrote:

Do you have any macros in that workbook? Maybe an event is firing that makes
excel think the workbook has been changed.

try opening excel in safe mode.
close excel
windows start button|Run
excel /safe

file|Open your workbook

Do you get the same prompt when you do the same stuff?

===
And with data validation, you only get that message when you select the cell,
right--not just mousing over the cell?

crimsonkng wrote:

To Dave, Anne, and Doug:

Thank you for your suggestions but, unfortunately, none of those are the case.

I went back to an earlier version of my spreadsheet, when I had only ONE
cell in which there was data validation (as opposed to my currrent
spreadsheet in which there are dozens of pick-list cells), and discovered
that this message appears ONLY when I pass my highlight over that one cell.
It's really wierd. I can move around the entire spreadsheet (about 300 rows
and 10 columns) but I get the "save changes?" message ONLY when my highlight
passes over the data-validation field. It's really bizarre.

Dan

"crimsonkng" wrote:

I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on the
cell ... I don't pull the list down or choose any data. Excel is acting as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ... that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation settings.
Do you want to extend data validation to these cells?" I answer "yes," and
the form comes up fine, with the proper data validation. But could this have
something to do with the erroneous exit message?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Dan found my email address in the message header and sent my the file.

My response...

The easy part first.

To get rid of that macro message, you have to delete the general modules
(module1, module2,...) from the project, too.

Debra Dalgleish has nice instructions for getting rid of macros at:
http://www.contextures.com/xlfaqMac.html#NoMacros

When I opened the workbook and closed it, I got this message:

Do you want to save the changes to 'Investment Quotation no macros.xls'?
Microsoft Office Excel recalculates formulas when opening files last saved by an
earlier version of Excel.

So that means....

This portion of my first post was a good question:

And excel likes to recalculate workbooks created in earlier versions. Is this
the case in your situation?

To follow up...

xl2002+ likes to recalculate any workbooks that were created in previous
versions.

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


You may have to adjust the version number 9.0 is xl2k, 10.0 is xl2002, 11.0 is
xl2003.

==========
Oh, oh. I use xl2003. I may have gotten that message just because I use a
newer version.

Do you know what version of excel created the workbook?

===
I've seen some people struggle with this--they ended up copying the worksheets
to a newly created workbook. You may want to try that technique.

Don't forget any names, code, and all that other stuff, too.


--
Dave Peterson


----- Original Message -----
From:
To:
Sent: Thursday, July 07, 2005 13:42
Subject: Excel spreadsheet from Dan (erroneous save message)


Dave:

I finally found your email address. (I hadn't seen it originally ... my
most recent post asked you to send your email address to me.)

Thank you so much for your willingness to look at this ... I know it's a lot
to ask so if you don't feel like dealing with it, I understand.

I thought that I deleted the macros but for some reason the "disable/enable"
macros message is still appearing when you open the spreadsheet.

Anyway .... here's the problem:

You can move the cursor anywhere except H6 and F188 and then exit the file
without the "save" message appearing. But if you merely pass the cursor
over H6 or F188, the save message appears when you exit the file.

Any idea why?

Thanks, again.




crimsonkng wrote:

Wow, Dave, yer a pal.

I removed all the macros so, zipped, it's down to 128KB. (Unzipped, it's
580KB.)

I know that it's a lot for me to ask you to look at it but if you really
don't mind, you can send your email address to me at and
then I'll send the file to you. (or how else should I send it to you? ... I
don't see your email address in any of the replies)

Dan

"Dave Peterson" wrote:

How big is the file after you zip it?

If it's pretty small (less than 250K), go ahead.

(I don't like opening unknown files and I don't like downloading large
attachments.)

crimsonkng wrote:

2000.

I wonder if that's the problem. Maybe I should upgrade.

I don't suppose that I could send the spreadsheet to you ... and have you
take a look? (I know that's asking a lot.)

You could disable the macro ... the problem still exists even if you disable
the macro.

Thanks for the responses/attempts.

"Dave Peterson" wrote:

I couldn't reproduce this in xl2003. What version of excel are you running?

(Maybe someone can test it and post back their results.)

crimsonkng wrote:

Yes, Dave, there's a 6,000-line macro. But it doesn't run automatically. (I
even "disabled macros" when I opened the file and I still got the erroneous
save message.)

I opened Excel in Safe mode and, yes, I still got that message when I merely
passed over the specific cell (H6) that has the data-validation.

All I can think is that there are lots of other cells that are dependent
upon H6. I guess Excel treats that (kind of) cell differently? I don't
know. It's just really wierd. I don't change anything in H6. I don't even
click it. I just move the cell highlight over it/past it. Maybe it's
because so many other cells are dependent upon the value in that cell.

Or maybe I merely found a bug in Excel?

"Dave Peterson" wrote:

Do you have any macros in that workbook? Maybe an event is firing that makes
excel think the workbook has been changed.

try opening excel in safe mode.
close excel
windows start button|Run
excel /safe

file|Open your workbook

Do you get the same prompt when you do the same stuff?

===
And with data validation, you only get that message when you select the cell,
right--not just mousing over the cell?

crimsonkng wrote:

To Dave, Anne, and Doug:

Thank you for your suggestions but, unfortunately, none of those are the case.

I went back to an earlier version of my spreadsheet, when I had only ONE
cell in which there was data validation (as opposed to my currrent
spreadsheet in which there are dozens of pick-list cells), and discovered
that this message appears ONLY when I pass my highlight over that one cell.
It's really wierd. I can move around the entire spreadsheet (about 300 rows
and 10 columns) but I get the "save changes?" message ONLY when my highlight
passes over the data-validation field. It's really bizarre.

Dan

"crimsonkng" wrote:

I am getting (what I think is) an erroneous "do you want to save your
changes?" message when I exit my .xls file (even though I didn't change any
data).

It happens ONLY after I rest the highlight on a cell in which there's a
pull-down list (data validation). Again, I merely REST the highlight on the
cell ... I don't pull the list down or choose any data. Excel is acting as
if I did change data (hence the "save changes?" exit message) but I didn't
change data. Is that how a data-validated cell is supposed to work ... that
if I just rest the highlight on the cell, that Excel thinks I changed the
data in that cell? (As long as I don't move the cell-highlight to a
data-validated cell, I don't get the save changes? message.)

More info, just in case it matters: the cell (B93) is a merged cell
(B93:F93). When I go to data validation, I get a message that says: "the
selection contains some cells that do not contain Data Validation settings.
Do you want to extend data validation to these cells?" I answer "yes," and
the form comes up fine, with the proper data validation. But could this have
something to do with the erroneous exit message?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson