I have an excel worksheet I would like to link into a Word document. I can get the object into my Word document, and it updates, when the Excel worksheet is changed.



My problem is formatting. The worksheet spans multiple pages. The function is exactly, well almost, what I need.

What can I do to allow the object to span multiple pages, with headings, etc.?

Paste as Hyperlink gives an appearance I am looking for, but does not offer the functionality I need.

Thank you

An embedded object can only span a single page. For multiple pages, you will need to use one of the other link formats. As for the headings, that would require you to create separate links for the header & body of the Excel table and have either:
• a Word Table, with the Excel header on one row and the balance of the worksheet in the second row; or
• the Excel header in the Word page header and the balance of the worksheet in the body of the document.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]