LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 6th 09, 09:10 PM posted to microsoft.public.excel.links
external usenet poster
First recorded activity by ExcelBanter: Aug 2006
Posts: 113
Default Excel query and link named range


I have book1 that has a query that brings down a list from access (name=
Project). I need to use this list in a drop down box (validation). I also
need to update the list periodically.

The problem is that my users are opening the spreadsheet as a template and
may need updates while using it. They do not have Access so they can't do
the update.

So, I wanted to create book1 with the list & query. Then have the template
(book2) reference the list in book1.

I tried:
1) doing a copy/paste/named range macro but that just seems like a workaround
2) creating a named range in book2 that references book1 but it only works
when book1 is open.

Any suggestions?

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
How Do I Query a Named Range JeffP-> Excel Worksheet Functions 2 February 3rd 09 11:11 PM
named range link na Excel Worksheet Functions 1 September 17th 08 06:21 PM
named range and link na Excel Worksheet Functions 1 September 16th 08 05:13 PM
Print Named Cells highlights web link to Excel range ExcelMonkey Excel Discussion (Misc queries) 1 June 12th 08 11:46 PM
Query Named Range Return Single Column Value JeffP-> Excel Worksheet Functions 5 November 29th 07 10:30 PM

All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017