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









Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
creating forms Fluffypink Microsoft Word Help 4 March 9th 05 04:17 PM
Boiletplates from Word Perfect linda Microsoft Word Help 1 January 28th 05 05:37 PM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 12th 05 11:30 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 09:02 AM


All times are GMT +1. The time now is 02:38 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"