Discussion Locked

Prob in creating dropdown in excel

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

while creating drop down in a workbook,when i tried to link it with another workbook via data->
validation,it shows :"u may not use references to other worksheets or workbooks for data validation rules."I m using Office 2003.

2 replies

by bfilmfan

The answer is right there. You may not use references to other worksheets of work books for data validation rules. The have to be within the same workbook.

by chitosunday

You can link by using a defined name as your link.
First create a name like "linkyes" in the file where your dropdown validation list is located and define it using the location of the file where your source data is. Then in the validation list, your formula should =linkyes and not
the filename and cell address of your source data.

This discussion is closed to new replies.