Thread: Excel to Word
View Single Post
  #11   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

Tables do create overhead, especially long ones. But you should not need
Paste Special to paste Excel data into Word as a simple table, so you might
try that method and see if the result is different. Also consider the
following list of reasons for excessive file size:

1. Fast Saves: Disable this at on the Save tab of Tools | Options.

2. Preview Pictu Clear the check box on the Summary tab of File |
Properties.

3. Versions (File | Versions): Make sure "Automatically save version on
close" is not turned on.

4. Revisions (Tools | Track Changes):
Highlight Changes: Make sure "Highlight changes on screen" is turned on
(or that "Final Showing Markup" is displayed).
Accept/Reject Changes: If "Accept All" or "Reject All" is available then
revisions are present; accept or reject all changes, then turn Track Changes
off.

5. Embedded True Type fonts (Tools | Options | Save); embedding fonts should
be avoided wherever possible.

6. Embedded graphics: When feasible, it is preferable to link the graphics.
That is, when you insert the graphic, click the arrow beside Insert in the
Picture dialog and choose Link to File rather than Insert or Insert and
Link.

7. Embedded objects: These are even worse than ordinary graphics saved with
the document. If you see an { EMBED } code, the graphic is an OLE object.
Unless you need to be able to edit the object in place, unlink it using
Ctrl+Shift+F9.

8. File format: Make sure you are saving as a Word document; in some cases
..rtf (Rich Text Format) files are significantly larger than .doc files.

9. Document corruption: See
http://www.mvps.org/word/FAQs/AppErrors/CorruptDoc.htm.

--
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 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!