J
John Hattersley
Hi All,
I've an issue with a web-query I could really use some help on.
Basically, I've a web-query that successfully returns data from an internal
web-site. Works fine, has been for a while. However, the data being pulled
down is getting very large and the query data is very shortly going to
extend beyond the limit of a worksheet (64K rows). I'd like to split the
query data across multiple worksheets, but can't find an easy way of doing
it. Also, I know I could split the query manually into two web-queries,
using table number or names, but there are a lot of tables and this would be
impractical to maintain.
Please do not respond with suggestion that do not use web-queries or Excel,
we're designing the next release to be scaleable, Excel was a prototype,
that we'd like to keep alive, short term.
Thanks, I appreciate your help.
Cheers,
John
I've an issue with a web-query I could really use some help on.
Basically, I've a web-query that successfully returns data from an internal
web-site. Works fine, has been for a while. However, the data being pulled
down is getting very large and the query data is very shortly going to
extend beyond the limit of a worksheet (64K rows). I'd like to split the
query data across multiple worksheets, but can't find an easy way of doing
it. Also, I know I could split the query manually into two web-queries,
using table number or names, but there are a lot of tables and this would be
impractical to maintain.
Please do not respond with suggestion that do not use web-queries or Excel,
we're designing the next release to be scaleable, Excel was a prototype,
that we'd like to keep alive, short term.
Thanks, I appreciate your help.
Cheers,
John