Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
Format a cell such that "#NAME?" reads/appears "N/A"? | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
save and restore "Workbook Menu Bar" & "Cell" menus | Excel Programming |