|
|
|
|
#1
06-08-2012, 01:35 PM
|
|||
|
|||
drop down list from external data source Excel 2007?
drop down lists can easily made by means of named ranges inside the same workbook/sheet.
Can I use this option also with data in an external data sheet ? The source field in the data validation tool won't allow me to use external references is this correct ? 
|
|
#2
08-03-2012, 05:41 AM
|
|||
|
|||
|
Hi Have a look at this link which may help you: http://blog.contextures.com/archives...erent-workbook Good Luck Tony
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 vba change external data source
|
excelledsoftware | Excel Programming | 1 | 07-17-2012 04:22 AM |
|
How can I revise Excel data source in merge?
|
navysalad | Mail Merge | 6 | 01-07-2012 06:50 PM |
| Edit Data Source- Linking template charts to new data | lbf | PowerPoint | 0 | 10-28-2011 12:19 PM |
|
Conditional data validation (list drop-down)
|
click4akshay | Excel | 2 | 04-28-2011 01:51 PM |
| Help w/ external data | bellest | Excel | 0 | 11-11-2005 12:51 PM |
Windows XP 
Office 2007
Hybrid Mode