Web Query: Excel doesn't respond when fetching around 16000 rows through WebQuer

K

Kirit

I have created a table with 16,000 rows.

When I fetch the data through IQY in excel 97 it shows 100%
cpu usage and fails to fetch data even after 1 hr. When I
open the same workbook using Excel 2000 it fetches the data
and displays it correctly within 5 minutes.

WebServer shows that data is correctly delivered to the
Client, but looks like Excel 97 is not able to refresh
itself with the large amount of data

Is this a known problem with Excel 97

Please send me mail at (e-mail address removed)

Thanks in advance.
Kirit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top