Working with Word and Excel

[joe busch]

(Excuse the multiple post, I placed this in pagelayout and decided it should
probably be under longdocs.)

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

 

[macropod]

Hi Joe,

It sounds like you've been pasting from some fairly large Excel
spreadsheets. When you paste from an Excel spreadsheet, the whole
spreadsheet is pasted in, but only the selected area is visible. try opening
the pasted spreadsheets from within Word and deleting any extraneous
formulae/data/formatting.

Cheers