Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 113
Default Excel query and link named range

Hi,

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?
Reply
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 4th 09 12:11 AM
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 11:30 PM


All times are GMT +1. The time now is 01:38 PM.

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

About Us

"It's about Microsoft Excel"