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

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

Dave Peterson Wrote:
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


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

JF


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

Sorry, I don't have another guess.

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

Ltat42a wrote:

Dave Peterson Wrote:
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

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

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