How Many Linked Excel Documents are too Many for a Word Document

Good afternoon,

I'm working on a forms manual in Word. The manual includes headers/footers, page numbering and the manual will include a table of contents. There are approximately 150 different forms. Approximately 100 of them are in Excel and the rest are in Word. The forms need to retain their formatting, so I was going to paste them as a picture, but I'm afraid that the manual will be too big and could become corrupt. The layout would be to have a page of instructions on how to fill out the form, followed by the form itself.

Does anyone have any advice for me?

Thank you!

July 20th, 2015 4:07pm

There is no particular limit for links, per se. Links to Excel workbook typically use LINK fields, though, and Word can support 2,147,483,647 fields per document. Even so, the more links you have, the slower it will be for Word to open the document. Therefore, you might consider maintaining your manual as a series of one-chapter files, so as to optimise performance. That (and regular backups) also minimises the consequences of any data corruption for a given chapter.
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2015 12:32am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics