Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-08-2012, 01:35 PM
Intruder Intruder is offline drop down list from external data source Excel 2007? Windows XP drop down list from external data source Excel 2007? Office 2007
Advanced Beginner
drop down list from external data source Excel 2007?
 
Join Date: Dec 2010
Posts: 56
Intruder is on a distinguished road
Default 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 ?
Reply With Quote
  #2  
Old 08-03-2012, 05:41 AM
OTPM OTPM is offline drop down list from external data source Excel 2007? Windows 7 32bit drop down list from external data source Excel 2007? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Have a look at this link which may help you: http://blog.contextures.com/archives...erent-workbook Good Luck Tony
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
drop down list from external data source Excel 2007? vba change external data source excelledsoftware Excel Programming 1 07-17-2012 04:22 AM
drop down list from external data source Excel 2007? 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
drop down list from external data source Excel 2007? 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 08:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft