Thread: Excel to Word
View Single Post
  #10   Report Post  
thebob
 
Posts: n/a
Default

I extended the experiment further. In the word document are two tables
totaling approximately 2000 rows of 8 column data. the word document,
complete, is 2.54Mb. I removed all the data and left the blank tables in the
document. The size reduced to 2.24Mb. I deduce from this, it is the table
structure (not the data) that is causing the large file size. So, I presume a
better question, "Is there a way to modify the table structure that will
result in a smaller file size?"

"Suzanne S. Barnhill" wrote:

If you're inserting it as an OLE object, then you're in effect embedding all
the Excel functionality into Word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"thebob" wrote in message
...
I'm sorry Jezebel; the answer to your question is:
Using Paste Special I selected Paste: & Microsoft Excel Worksheet Object

If I use HTML it truncates the Excel table.

I don't understand that if Office is all supposed to be OLE, why does a

200k
Excel table turn into a 2Mb beast in Word?

"Jezebel" wrote:

OK, so what option DID you use?


"thebob" wrote in message
...
I did not link it to the original. It doesn't need to auto-update from
Excel.
It's a report; attendance listing.

"Jezebel" wrote:

Which option did you choose when using Paste Special?



"thebob" wrote in message
...
My 213k Ecxel table bloats my 105k Word Doc to 2.5Mb - Why? I've

tried
copy &
paste, copy & paste special. Both still bloat the Doc. Help!