If you insert anything from Excel as an OLE object (item 8), then, yes, you
will have a huge document. If you don't need to be able to edit the table
using Excel tools inside Word, there's no need to do this. And if you don't
need to be able to update the tables in Excel and have the results
propagated to Word, there's no need to link the tables, either. If you just
paste the data in, you get a Word table and keep the file size reasonable.
--
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.
"cynwalker" wrote in message
...
Ok. I was incorrect in my last posting. When all the tables are removed
the
file was small. I must have had tables still in it when I did that the
first
time. And...my tables are actually excel tables. So I went through the
documents and made all 62 excel tables into word tables which made the
document 9 MB. Much more manageable. I also checked all of your
suggestions
and the document was already set up that way. Unfortunately, we need to be
able to use excel tables do you know of a way to integrate them into the
document better?
"Suzanne S. Barnhill" wrote:
The size limit for Word documents is 32 MB of text. I would assume this
included tables (graphics are exempt). I don't see how any amount of
formatting or number of tables could result in a document this size. I
have
a 350-page document with literally hundreds of tables, plus numerous
photos
and a massive index, and it is just 3.26 MB. There's something fishy
about
your document. There are a number of reasons for excessive file size,
including:
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. Keep track of formatting (Tools | Options | Edit). This is reportedly
a
major cause of file bloat in Word 2002 and above.
6. Embedded True Type fonts (Tools | Options | Save); embedding fonts
should
be avoided wherever possible.
7. 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.
8. 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.
9. 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.
10. 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.
"cynwalker" wrote in message
...
I have a document with a lot of table in it and it goes to 149 MB. But
even
when I take out all of the tables its still 22MB because of the styles
formatting for the table of contents. Is there any way to make this
any
smaller? The document itself is only 90 pages or so and is just one
Section
of a report or is it just getting impossible to use Word as a word
processing
package?