Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Data Validation
I am trying to insert a drop-down list into a cell using Data Validation. The
list is from another workbook. I have followed the instructions given in the help file, but everytime I work through them I end up with the following error message:- "You may not use references to other worksheets or workbooks for Data Validation criteria!" This message appears to contradict with the information in the help file. Can anyone offer some guidance as to where I am going wrong? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Data Validation
Hi Hessen,
sorry but, I think you can't do it. the validation list must be on the same worksheet. hth regards from Brazil Marcelo "Hessen_Wraith" escreveu: I am trying to insert a drop-down list into a cell using Data Validation. The list is from another workbook. I have followed the instructions given in the help file, but everytime I work through them I end up with the following error message:- "You may not use references to other worksheets or workbooks for Data Validation criteria!" This message appears to contradict with the information in the help file. Can anyone offer some guidance as to where I am going wrong? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Data Validation
You can use a list from another open workbook, as described he
http://www.contextures.com/xlDataVal05.html Hessen_Wraith wrote: I am trying to insert a drop-down list into a cell using Data Validation. The list is from another workbook. I have followed the instructions given in the help file, but everytime I work through them I end up with the following error message:- "You may not use references to other worksheets or workbooks for Data Validation criteria!" This message appears to contradict with the information in the help file. Can anyone offer some guidance as to where I am going wrong? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Data Validation
You can use a list on a different worksheet, if the list is named, as
described he http://www.contextures.com/xlDataVal01.html Marcelo wrote: Hi Hessen, sorry but, I think you can't do it. the validation list must be on the same worksheet. hth regards from Brazil Marcelo "Hessen_Wraith" escreveu: I am trying to insert a drop-down list into a cell using Data Validation. The list is from another workbook. I have followed the instructions given in the help file, but everytime I work through them I end up with the following error message:- "You may not use references to other worksheets or workbooks for Data Validation criteria!" This message appears to contradict with the information in the help file. Can anyone offer some guidance as to where I am going wrong? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Data Validation
thanks Debra
"Debra Dalgleish" escreveu: You can use a list on a different worksheet, if the list is named, as described he http://www.contextures.com/xlDataVal01.html Marcelo wrote: Hi Hessen, sorry but, I think you can't do it. the validation list must be on the same worksheet. hth regards from Brazil Marcelo "Hessen_Wraith" escreveu: I am trying to insert a drop-down list into a cell using Data Validation. The list is from another workbook. I have followed the instructions given in the help file, but everytime I work through them I end up with the following error message:- "You may not use references to other worksheets or workbooks for Data Validation criteria!" This message appears to contradict with the information in the help file. Can anyone offer some guidance as to where I am going wrong? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Data Validation
Thanks Debra. I've worked through this and I'm still not having much success.
I shall try again and see if I've used the correct syntax. It would be nice to know that someone else has achieved the results on another PC using these instructions. Hessen. "Debra Dalgleish" wrote: You can use a list from another open workbook, as described he http://www.contextures.com/xlDataVal05.html Hessen_Wraith wrote: I am trying to insert a drop-down list into a cell using Data Validation. The list is from another workbook. I have followed the instructions given in the help file, but everytime I work through them I end up with the following error message:- "You may not use references to other worksheets or workbooks for Data Validation criteria!" This message appears to contradict with the information in the help file. Can anyone offer some guidance as to where I am going wrong? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Data Validation
If you're still having trouble, post another message here, describing
what happens when you try the instructions. Then, someone may be able to help solve the problem. Hessen_Wraith wrote: Thanks Debra. I've worked through this and I'm still not having much success. I shall try again and see if I've used the correct syntax. It would be nice to know that someone else has achieved the results on another PC using these instructions. Hessen. "Debra Dalgleish" wrote: You can use a list from another open workbook, as described he http://www.contextures.com/xlDataVal05.html Hessen_Wraith wrote: I am trying to insert a drop-down list into a cell using Data Validation. The list is from another workbook. I have followed the instructions given in the help file, but everytime I work through them I end up with the following error message:- "You may not use references to other worksheets or workbooks for Data Validation criteria!" This message appears to contradict with the information in the help file. Can anyone offer some guidance as to where I am going wrong? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Data Validation
Aside from Debra who assiduously tests all her work I can state that her method
works for me on Excel 2003. Gord Dibben MS Excel MVP On Wed, 12 Jul 2006 06:03:02 -0700, Hessen_Wraith wrote: Thanks Debra. I've worked through this and I'm still not having much success. I shall try again and see if I've used the correct syntax. It would be nice to know that someone else has achieved the results on another PC using these instructions. Hessen. "Debra Dalgleish" wrote: You can use a list from another open workbook, as described he http://www.contextures.com/xlDataVal05.html Hessen_Wraith wrote: I am trying to insert a drop-down list into a cell using Data Validation. The list is from another workbook. I have followed the instructions given in the help file, but everytime I work through them I end up with the following error message:- "You may not use references to other worksheets or workbooks for Data Validation criteria!" This message appears to contradict with the information in the help file. Can anyone offer some guidance as to where I am going wrong? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - Data Validation
Thanks Gord. I wasn't meaning to doubt Debra. I hadn't realised Debra had
tried it out already and was looking for confirmation that it worked. Many thanks for everyones help. Hessen. "Gord Dibben" wrote: Aside from Debra who assiduously tests all her work I can state that her method works for me on Excel 2003. Gord Dibben MS Excel MVP On Wed, 12 Jul 2006 06:03:02 -0700, Hessen_Wraith wrote: Thanks Debra. I've worked through this and I'm still not having much success. I shall try again and see if I've used the correct syntax. It would be nice to know that someone else has achieved the results on another PC using these instructions. Hessen. "Debra Dalgleish" wrote: You can use a list from another open workbook, as described he http://www.contextures.com/xlDataVal05.html Hessen_Wraith wrote: I am trying to insert a drop-down list into a cell using Data Validation. The list is from another workbook. I have followed the instructions given in the help file, but everytime I work through them I end up with the following error message:- "You may not use references to other worksheets or workbooks for Data Validation criteria!" This message appears to contradict with the information in the help file. Can anyone offer some guidance as to where I am going wrong? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use template wizard with data tracking in Excel 2003? | Excel Discussion (Misc queries) | |||
Referencing Data in a Pivot table. More Excel 2003 misery | Excel Worksheet Functions | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
problem with downloading Data into Excel 2003 | Excel Discussion (Misc queries) |