Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 18th 17, 02:59 PM
Member
 
First recorded activity by ExcelBanter: Apr 2006
Posts: 54
Default Can I keep external connections in a table?

Currently I have worksheet that pulls in a query from an external source. Then I have another worksheet that references the external query, this sheet is defined as a table. I can write formulas like =INDEX(Table,MATCH([@Co],Table[Company],0),MATCH(Table2[[#Headers],[Level]],Table[#Headers],0)) from the table but not the query. My question is there any way to combine the query and the table so I don't have to use 2 separate sheets? If I try to define the external query as a table it asks "Do you want to convert the selection to a table and remove all external connections?" I would like to convert to a table but I need to keep external connections. Any assistance would be greatly appreciated!!

Thanks

Dave

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
Refreshing NON-embedded External Data Connections hutteto Excel Programming 1 March 4th 11 11:07 AM
External Data Connections Error Steph2010 Excel Discussion (Misc queries) 0 February 10th 10 06:25 AM
External data connections CellShocked Excel Worksheet Functions 2 October 25th 09 01:58 AM
How do I permanently remove external data connections? DOUBLEB Excel Worksheet Functions 0 January 9th 09 07:55 PM
Lost External Data Connections Jeff C Excel Discussion (Misc queries) 0 July 12th 07 10:14 PM


All times are GMT +1. The time now is 02:54 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017