Excel slow to open large HTML file

D

David McCulloch

Excel 2000 takes a few minutes to open an HTML table of about 2,000 rows
(with about 20- to 30-columns each). If I save the file in an Excel format
and re-open it, Excel completes the open within 1-second.

Is there any way to improve Excel's performance?

If not, what options do I have?

Is there another format that Excel opens in much less time that also offers
some simple formatting capabilities (ex: colored headers, sized columns,
numeric cells with leading zeroes, etc.)?

Is there something I could do to the HTML to make it easier for Excel to
open?

Any help would be greatly appreciated!

Dave
 
D

David McRitchie

Hi Dave,
An HTML file is not an Excel file, so it has to be converted.
In fact with Round Tripping, I would expect that anything
that Microsoft will Round Trip with will also add a lot of
garbage into file so that you the proper rendition in other
Office Programs (Excel, Front Page, Power Point, and
since HTML is supported include HTML).
What is the purpose of storing a file strictly for use in Excel as an HTML
file.
 
D

David McCulloch

I have a web application from which people click a button to download data
into Excel. Today, the application sends Excel (via Java) an HTML table
that takes Excel a LONG time to open. If that file were native Excel, Excel
would open it very quickly.

Any suggestions for improving Excel's open time?

Dave

David McRitchie said:
Hi Dave,
An HTML file is not an Excel file, so it has to be converted.
In fact with Round Tripping, I would expect that anything
that Microsoft will Round Trip with will also add a lot of
garbage into file so that you the proper rendition in other
Office Programs (Excel, Front Page, Power Point, and
since HTML is supported include HTML).
What is the purpose of storing a file strictly for use in Excel as an HTML
file.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Excel 2000 takes a few minutes to open an HTML table of about 2,000 rows
(with about 20- to 30-columns each). If I save the file in an Excel format
and re-open it, Excel completes the open within 1-second.

Is there any way to improve Excel's performance?

If not, what options do I have?

Is there another format that Excel opens in much less time that also offers
some simple formatting capabilities (ex: colored headers, sized columns,
numeric cells with leading zeroes, etc.)?

Is there something I could do to the HTML to make it easier for Excel to
open?

Any help would be greatly appreciated!

Dave
Click to expand...
Click to expand...
 
Top