View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default Excel 2000/Xp vs Excel 2003

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 wrote:

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

--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=478417


--

Dave Peterson