Combining a word and excel file, keeping a logical pagenumbering when combined in PDF.

If you name a range in Excel, then copy & paste it into Word using Paste Special, with the 'paste link' option and your preferred paste format, any subsequent changes to the range spanned by the name (whether as to cell values or the rows/columns) should be reflected in the Word document.

Your best bet is to copy the data from Excel to Word.

As mentioned you can do this in a linked fashion in which changes to the Excel file impact the content of the Word document. You could also embed the Excel file in the word document, though this isn't conducive to printing.

When linked, it will span multiple pages and update as the underlying Excel file is updated. The down side is the files are still separate, so for the Excel content to be visible, the viewer of the Word file needs access to the additional Excel file.

Originally Posted by Zer0Cool

You could also embed the Excel file in the word document, though this isn't conducive to printing.

When linked, it will span multiple pages and update as the underlying Excel file is updated.

Do note that anything inserted into Word in the Excel worksheet or picture formats cannot span multiple pages; a different paste format would be required for that.

@macropod is correct, I should have been clearer than "isnt conducive to printing", as I did mean to indicate it would not span pages.