Make a drop-down list from another workbook. How to fix Excel Data Validation not working.
On the Contextures blog there are instructions for using a list from another workbook in Excel 2007 and later. Introduction.
Drop Down from a List in Another Workbook. Important Note: For the data validation to work, the workbook that contains the list must be open, in the same instance of Excel.
Can you create a Data Validation Dropdown list that uses data from another workbook as a source?
Now we go to another Workbook called DestinationDynamicRange.xlsx and there we go to Power Query tab and choose From File and From Excel.
Dropdown - Manual List If you're using Excel 2007 or later you can create a drop down from a source range that is located in another worksheet.
Home » Celeb & Entertainment » Excel 2007 Use Drop Down List.
If you’re using Excel 2007 or later you can create a drop down from a source range that is located in another worksheet. To create a list from a range
While you can create an Excel drop down using worksheet or workbook, it is important to understand before you begin that the worksheet with the source list must be open for the data validation tool to work.
I used data validation including drop-down lists in the 2007 format of Excel. when i open the workbook in 2003 format, the validation does not work. Please assist in recifying this without having to redo the entire workbook.