Please can someone help. Have been working on quite a complex spreadsheet
and have various sets of drop-down Data Validation cells. These have been
working fine, the other day I saved it then today I went to open it up to do
further edits, the Data Validation cells are now not working, the commands
are still in place but the drop-down arrow has now gone, all other sheets in
the workbook are okay, except this one sheet, if I try and create new Data
Validation commands on this particular worksheet, again, the drop-down arrow
does not display although the command still works, there is no protection
assigned and the setting of this worksheet is the same as all the others in
the workbook, a mystery which I hope someone can help with.

Recollect a posting by Bob Phillips to try "Open and Repair" in XL2003. Click
File Open, navigate to folder, select the file, then click the arrow
dropdown on the right of the "Open" button choose "Open and Repair". Good
luck !

Do hang around for other insights ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tarby" wrote:
Please can someone help. Have been working on quite a complex spreadsheet
and have various sets of drop-down Data Validation cells. These have been
working fine, the other day I saved it then today I went to open it up to do
further edits, the Data Validation cells are now not working, the commands
are still in place but the drop-down arrow has now gone, all other sheets in
the workbook are okay, except this one sheet, if I try and create new Data
Validation commands on this particular worksheet, again, the drop-down arrow
does not display although the command still works, there is no protection
assigned and the setting of this worksheet is the same as all the others in
the workbook, a mystery which I hope someone can help with.

Dear Max,

You are a star, myself and my manager who has been working equally as hard
on this file, thank you... your solution has worked a treat and the
validation commands have now been restored.

Thanks again, "Tarby"

"Max" wrote:

Recollect a posting by Bob Phillips to try "Open and Repair" in XL2003. Click
File Open, navigate to folder, select the file, then click the arrow
dropdown on the right of the "Open" button choose "Open and Repair". Good
luck !

Do hang around for other insights ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tarby" wrote:
Please can someone help. Have been working on quite a complex spreadsheet
and have various sets of drop-down Data Validation cells. These have been
working fine, the other day I saved it then today I went to open it up to do
further edits, the Data Validation cells are now not working, the commands
are still in place but the drop-down arrow has now gone, all other sheets in
the workbook are okay, except this one sheet, if I try and create new Data
Validation commands on this particular worksheet, again, the drop-down arrow
does not display although the command still works, there is no protection
assigned and the setting of this worksheet is the same as all the others in
the workbook, a mystery which I hope someone can help with.

Great to hear that worked for you! Thanks for feeding back.
Full credits deserving to Bob Phillips for his posting on this.
I'm sure Bob would be happy to hear that it worked for you.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tarby" wrote in message
...
Dear Max,

You are a star, myself and my manager who has been working equally as hard
on this file, thank you... your solution has worked a treat and the
validation commands have now been restored.

Thanks again, "Tarby"