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

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



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

[Dave Peterson]

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