Excel 2000/Xp vs Excel 2003

[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

 

[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.

 

[Ltat42a]

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.



http://www.excelforum.com/showthread.php?threadid=478417

The worksheet is not protected, and the cell is not locked.

JF

 

[Dave Peterson]

Sorry, I don't have another guess.

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