| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data validation quirk
I have created a worksheet in which users enter data in various fields
via dropdown lists. These dropdown lists were made using Excel's standard data validation procedu Data|Validation|Settings -- Allow:List -- Source:=A range of cells named "Dates", on a separate worksheet. 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 worksheet 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 sheet protection is removed. Does anyone know why? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation quirk
Are you sure that you locked the cell and protected the worksheet in xl2k?
I don't think that there has been a change in behavior. bwb wrote: I have created a worksheet in which users enter data in various fields via dropdown lists. These dropdown lists were made using Excel's standard data validation procedu Data|Validation|Settings -- Allow:List -- Source:=A range of cells named "Dates", on a separate worksheet. 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 worksheet 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 sheet protection is removed. Does anyone know why? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation quirk
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 worksheet in which users enter data in various fields via dropdown lists. These dropdown lists were made using Excel's standard data validation procedu Data|Validation|Settings -- Allow:List -- Source:=A range of cells named "Dates", on a separate worksheet. 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 worksheet 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 sheet protection is removed. Does anyone know why? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation quirk
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 worksheet in which users enter data in various fields via dropdown lists. These dropdown lists were made using Excel's standard data validation procedu Data|Validation|Settings -- Allow:List -- Source:=A range of cells named "Dates", on a separate worksheet. 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 worksheet 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 sheet protection is removed. Does anyone know why? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation quirk
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 worksheet in which users enter data in various fields via dropdown lists. These dropdown lists were made using Excel's standard data validation procedu Data|Validation|Settings -- Allow:List -- Source:=A range of cells named "Dates", on a separate worksheet. 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 worksheet 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 sheet protection is removed. Does anyone know why? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data validation quirk
(Not that I didn't trust your response, ma'am.)
Yeah, that's obvious. <g Anyway, this MSKB article has a bit more information on the previous behaviour: XL97: Error When Using Validation Drop-Down List Box http://support.microsoft.com/default.aspx?id=157484 Dave Peterson wrote: You made me fire up my work pc xl2k (again). It really did change <vbg. 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 worksheet in which users enter data in various fields via dropdown lists. These dropdown lists were made using Excel's standard data validation procedu Data|Validation|Settings -- Allow:List -- Source:=A range of cells named "Dates", on a separate worksheet. 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 worksheet 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 sheet protection is removed. Does anyone know why? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Dave Peterson -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Summarizing Quirk - Please Help | Excel Discussion (Misc queries) | |||
| Conditional formatting quirk | Excel Discussion (Misc queries) | |||
| An Interesting vba Excel quirk | Excel Discussion (Misc queries) | |||
| AutoFilter Quirk | Excel Discussion (Misc queries) | |||
| a VLOOKUP quirk | Excel Worksheet Functions | |||
Hybrid Mode
