Connecting Excel tables to Word without display errors (Office XP, 2003, 2007)

Excel tables can be inserted in Word such that any changes made automatically appear in Word as well. This works well at least for small tables, but Word always cuts off bigger ones at the end of the first page.

Since Word actually has problems presenting Excel tables as objects, you cannot insert these through ‘Insert | Object’ in the document. First, select the desired area in Excel that has be copied and copy it with [Ctrl] + [C] in the clipboard. Then open the Word document, place the cursor in the position where the table should appear and select ‘Edit | Paste’. In the following, dialog of the same name, select the option ‘Insert Link’ and in the list ‘As’ enter ‘Rich Text Format (RTF)’. After a mouse click on ‘OK’, Word inserts the table correctly, running through several pages in the document. The table use formatting of a standard paragraph by default, making a few subsequent formatting changes necessary.

Note: If you place the cursor in the table in the Word document and activate the option to view field codes using the key combination [Alt] + [F9], you will see the actual reference (link) to the Excel table in the document.