Embedding an excel file into word

L

Lightfoot

I want to embed an financial statement into Word that is several pages long.
How do I embed into word and make it several pages in length, instead of it
just being the picture of the whold document in one page? Thanks!

I am using Office 2003 products
 
T

TedMi

In Excel, select the extent of cells you want to appear in the doc and Edit |
Copy to the clipboard.
In Word, position the cursor where the statement is to begin, Edit | Paste
Special, check Paste Link, select RTF, OK.
That creates a Word table in the doc, linked to the data in the worksheet.
Each time you open the doc, you will be asked whether to update the linked
data. Thus, changes to the spreadsheet will be reflected.
You may have to play with the table's formatting - font, column widths, etc.
 
D

Doug Robbins - Word MVP

It is not possible for an object in Word to span multiple pages.

You would need to embed a page worth's at a time.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
Top