|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 27th, 2009, 04:51 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
How do i reference an external workbook for data validation?
I have followed the Office Assistant guidance but an error message appears
stating "you cannot reference cells in an external workbook". I couldn't make sense of the online help information regarding this error and wonder if anyone else can tell me how to get round it. Thanks. 
|
|
#2
October 27th, 2009, 05:27 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i reference an external workbook for data validation?
You need a named range in the external WB for your list source.
See Debra Dalgleish's site for instructions. http://www.contextures.on.ca/xlDataVal05.html Note: both workbooks must be open in order to select from dropdown. Gord Dibben MS Excel MVP On Tue, 27 Oct 2009 09:51:02 -0700, Dex wrote: I have followed the Office Assistant guidance but an error message appears stating "you cannot reference cells in an external workbook". I couldn't make sense of the online help information regarding this error and wonder if anyone else can tell me how to get round it. Thanks.
|
|
#3
October 27th, 2009, 06:13 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i reference an external workbook for data validation?
check here
http://www.contextures.on.ca/xlDataVal05.html "Dex" wrote: I have followed the Office Assistant guidance but an error message appears stating "you cannot reference cells in an external workbook". I couldn't make sense of the online help information regarding this error and wonder if anyone else can tell me how to get round it. Thanks.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
