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