Excel Links - File Size Problem

P

Partho

I have a Word file which has a large number of links to an
Excel spreadsheet. There are about 150 such links. The
contents of the Word file are otherwise not very great –
about 24 pages of text with a lot of empty space. The size
of the file is now 8.3 megabytes, which is much bigger
than it should be. I believe the size should be roughly 1
to 1.5 megabytes. In fact the size seemed to suddenly
shoot up from 1.2 to 8.3 megabytes after I added the last
4 or 5 Excel links. The large size of the file obviously
makes it very time consuming to open and save and
generally work on it.

Does anybody have any ideas on why the size is so large?
Any suggestions about how I can clear out any junk that
may be in the file and reduce the size? I tried copying
the contents to a new document but that did not make any
difference.

My thanks to Cindy and Doug of this newsgroup who enabled
me to update the Excel file links in this file.

Any help with this file size problem would be greatly
appreciated.

Regards,
Partho
 
J

Jonathan West

There may be a bit o corruption in the document. Try copying the text - all
*except* for the final paragraph mark - into a new document and save that.

--
Regards
Jonathan West - Word MVP
MultiLinker - Automated generation of hyperlinks in Word
Conversion to PDF & HTML
http://www.multilinker.com
 
P

Partho

Jonathan,

Could you please explain what is meant by final paragraph
mark?

Regards,
Partho
 
J

Jonathan West

Partho said:
Jonathan,

Could you please explain what is meant by final paragraph
mark?

If you show non-printing characters (by clicking the button on the toolbar
that looks like this ¶) then you will see that every pragraph ends with a ¶
character. Make sure you don't select the last one in the document.

--
Regards
Jonathan West - Word MVP
MultiLinker - Automated generation of hyperlinks in Word
Conversion to PDF & HTML
http://www.multilinker.com
 

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

Top