From Excel to Word

M

Mike

Hello, I am trying to paste a 4 x 3636 table from Excel into a Word table.
However, the size jumps from 365Kb to 5.7 Mb. Why is it growing THAT big?
 
M

Mike

By the way, you might be raising an issue. The Excel file that I am using is
supplied to me by a customer, and I have no idea what that person's Excel
version might be.
 
B

Beth Melton

First go to File/Properties and on the Summary tab, make sure "Save Preview
Picture" isn't selected. If the embedded Excel object appears on the first
page and is part of the preview picture saved with the file then that's the
likely cause of the file bloat you are encountering.

IIRC, this was more of an issue in Word 2002 than in other versions which is
why knowing which version you are using is helpful information. :)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
M

Mike

Thank you, Beth, for your kind assistance. I do appreciate it.

That box was not checked, so that is probably not the cause. Might there be
some other hidden commands that might cause this?
 
H

Henk57

Mike;2620093 said:
Thank you, Beth, for your kind assistance. I do appreciate it.

That box was not checked, so that is probably not the cause. Might
there be
some other hidden commands that might cause this?

:
-
First go to File/Properties and on the Summary tab, make sure "Save
Preview
Picture" isn't selected. If the embedded Excel object appears on the
first
page and is part of the preview picture saved with the file then
that's the
likely cause of the file bloat you are encountering.

IIRC, this was more of an issue in Word 2002 than in other versions
which is
why knowing which version you are using is helpful information. :)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

"Mike" (e-mail address removed) wrote in message
Office 2002.

:
-
What versions of Word are you using?--
--

"Mike" (e-mail address removed) wrote in message
Hello, I am trying to paste a 4 x 3636 table from Excel into a Word

table.
However, the size jumps from 365Kb to 5.7 Mb. Why is it growing THAT

big?
Click to expand...

How do you exactly paste it? "As linked" is notably a file inflator.
 
B

Beth Melton

M

Mike

I select A1 then scroll down to D3636 and copy. I open a brand new Word file
and create a table with 4 columns and 3636 rows, select the the table in the
same way I did the Excel cells and paste.

I thought there might be some embedded commands or something in Excel that
was causing this bloat or something else I could turn off. Something strange
is going on moving from 367K to 5.7M.
 
B

Beth Melton

I fired up an old laptop with Word 2002 and tried it and my results were
similar: a new blank Word document with 3600 rows of Excel data containing
numbers only (default formatting), resulted in a 3.75 MB file size. I don't
know what your Excel data consists of so that may account for the difference
in file size.

Pasting the Excel data in the document, instead of inserting a Word table
first, may decrease the file size slightly. I didn't test this since Word
kept locking up on me pasting only 1000 rows at a time so it took awhile to
even get my first test accomplished. (There's a reason why it's my old
laptop. <grin>)

I don't know if this helps much but it does appear I'm able to duplicate
what you are encountering.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
M

Mike

LOL :)

Thanks for really going out of the way. At least you have proven I am not
crazy or incompetent.

I did try a dozen variations beyond what I reported to you (as I thought
what I reported was the "cleanest," maybe even the most straightforward
manner to accomplish this task.)

It will remain a mystery I guess.
 
B

Beth Melton

You're welcome. :)

Sorry I didn't have a better answer but as you noted, you have confirmation
you aren't crazy or incompetent. (Which I never thought was the case to
begin with. ;-) )

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
 

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

Similar Threads

Embed the same Excel multiple times 0
Paste to excel from word - auto format problem 1
How to make a large Word file sendable by email? 0
Grow/Shrink Text gradually from slide to slide 0
Word Template and Normal Style 1
How to paste this down? 3
Excel --> Word 4
Scroll does not show preview 0

Top