word table implementation

  • Thread starter Thread starter clearybrendan
  • Start date Start date
C

clearybrendan

Hi, I am trying to put several very large excel tables into a word
document, after figuring out word doesn't do multi-page embedded excel
worksheets i tried copy and pasting the contents of the worksheet in
the word doc which will work but the increase in the file size of the
word document is very large. For example while a table of 9100 cells
results in a 94kb excel file, the same table stored in word without
anything else in the document results in a file of 1900kb. Thats 10
bytes per cell in excel and over 200 bytes per cell in word. I am
aware that i can paste the table as unformatted text or create several
page sized embedded excel sheets but neither of these two options are
particularly satisfactory. Is anyone aware of another solution? Thanks.
 
When you Paste, select Paste Special and check the Link box.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 

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

Back
Top