#1
|
|||
|
|||
Connections in excel
Hi,
Have an application for which I am creating connections in excl sheet in 2007. The URL that I provide at the connection has many tables which each of my connection points to. For e.g I have 10 connections with the same URL each pointing to a table with Id Table<x> where x varies from 1 to 10. But in actual that URL yields an HTML having all those tables. So when I click refresh all, excel calls the same URL 10 times which is unnecessary (Remember I get all the data for those tables with a single call).. Is there any way where I have 1 connection for all those tables? (Note : Those tables are in different sheets of my excel file) Please help me. Since there are 10 connection it makes my application life pathetic as there is a lot of processing invoved.. Thanks, Pravat |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Hyperlinks crash Excel programme | martinlest | Excel | 8 | 01-26-2011 04:23 AM |
Opening multiple Excel files within the same Excel window. | lost9471 | Excel | 2 | 05-01-2010 01:57 PM |
Mail Merge--different connections of Access in Single Word File. | Goldenbird | Mail Merge | 3 | 06-12-2009 06:42 AM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |