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