Working with Word and Excel

[joe busch]

Basic facts -- Using Word and Excel 2000 on aWindows 200 platform

I have a 70 page document that is 191 Kilobytes, when I start to add in some
Excel tables (about 44) the document gets to about 200 pages. The problem
is the file size blossoms to 117 Megabytes!

This was done inserting the Excel pastes as an Excel object. If you use the
picture ooption the table does not come in fully, rows are cut off and do
not appear anywhere. Linking the files doesn't work and seems to corrupt
the Word doc.


Any suggestions, best practices, ideas are welcome and encouraged.

Thanks in advance,

Joe

 

[Guest]

Joe,

Unfortunately word is not robust enough to handle that
type of torture.
I suggest separating your document into multiple
documents, in which the graphic section is a separate
file, which is managable (<10MB). You can keep the page
header the same and modify the starting page number in the
file.

You other option is to take a screen shot of the table and
save as a .jpg file with max compression and insert that
way. This method will obviously sacrifice clarity.

Don't know if this helps, but there is no magic answer on
helping Word handle extremely large, graphic intense
files. Be prepared to be patient.

 

[Suzanne S. Barnhill]

Unless you need to be able to update the data from Excel, don't insert it as
an OLE object. Just copy/paste. The data will be inserted in a Word table,
where you can format it as you like.