View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Excel 2000 using Web Query is slow on Excel 97

Dear all,

I am getting trouble on running an excel that gets external data from
Web query.
I created it from Excel 2000 and it works fine.

However, it is quite slow on Excel 97. Around 3 to 5 minutes to
retrieve the HTML data onto four worksheets.

Unforunately over 90 % of our users are using Excel 97. Anyone has
the same experience like me ? Can share the solution ? Thanks in
advance.

Regards,
Christine