Re: data validation quirk

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dave Peterson (ec35720_at_netscapeXSPAM.com)
Date: 02/03/05 

Date: Wed, 02 Feb 2005 20:11:33 -0600

You made me fire up my work pc xl2k (again).

It really did change <vbg>.

(Not that I didn't trust your response, ma'am.)

Dave Peterson wrote:
>
> Oopsie.
>
> I didn't remember it being different in xl97/xl2k.
>
> Debra Dalgleish wrote:
> >
> > I can't tell you why, but this behaviour was changed in Excel 2002. The
> > cell will have to be unlocked so users can use the data validation
> > dropdown in Excel 2002 or Excel 2003.
> >
> > bwb wrote:
> > > I have created a work*** in which users enter data in various fields
> > > via dropdown lists. These dropdown lists were made using Excel's
> > > standard data validation procedure: Data|Validation|Settings -->
> > > Allow:List --> Source:=A range of cells named "Dates", on a separate
> > > work***.
> > >
> > > It was discovered that users could bypass this validation by pasting
> > > data copied from another cell. We were happy to find that by
> > > protecting the work*** users could still use the dropdown lists to
> > > enter values, but were unable to paste other values into these cells.
> > >
> > > This was true for Excel 2000 on Windows 2000. But a couple of users
> > > have tried running this file on Windows XP with Excel 2003. They are
> > > unable to enter data via the dropdown lists unless the *** protection
> > > is removed.
> > >
> > > Does anyone know why?
> > >
> >
> > --
> > Debra Dalgleish
> > Excel FAQ, Tips & Book List
> > http://www.contextures.com/tiptech.html
>
> --
>
> Dave Peterson 

-- 
Dave Peterson
Quantcast