Excel 2000/Xp vs Excel 2003

L

Ltat42a

Question regarding the drop down selection in Excel between these
versions.

I have a spreadsheet that was created in Excel XP. I have a drop down
selection
that users select. It works well in Excel 2000 & XP, it doesn't allow
me to select
an option when I open it in Excel 2003.

Any suggestions??


Thanx...JF
 
D

Dave Peterson

Is the dropdown from Data|Validation?

If yes, then unprotect the sheet, unlock the cell (format|cells|protection tab),
then reprotect the sheet.

xl2003 got a little more stringent in how it deals with locked cells with
data|validation on protected sheets.
 
D

Dave Peterson

Sorry, I don't have another guess.

(In fact, I'm not sure if the behavior changed with xl2003 or xl2002.)
 
Top