I have been using the method u decribed to import a dynamic table from but it doesnt do what i need it to.
I have tables which get refreshed every fortnight, thus resulting in the tables not having a set number rows.
Do you know of any method whereby the linked table in word will reflect the number of rows in the excel table.
ie. if there was 7 rows in the excel table, the linked table in word would show 7 rows but if 2 rows where added to the excel table giving it 9 rows, then the linked table would show 9 rows. Alternatively, if 4 rows where removed from the excel table leaving it 5 rows, then the linked table would only display 5 rows.

I am making certificates for a fire school. I have the first and last name in an Excel spreadsheet and would like to import each first/last name into each certificate. The certificates are pre-printed with most of the data, I just need to add the persons name. I am using Office 2007, ugh.
Thanks

hi i just did the copy and special paste with word and excel 2007.
in my excel sheet i have the spread sheet set up in landscape mode so that the financial date can be all on one page.
when i paste it to word only half the cells are visible. the other half are of the page in portrait mode.
if i try to adjust any aprmeters in word ie change the page to landscape from portait the whole word document changes and that is not what i need.
basically i need to spin the excel sheet so it can be read in a report and printed all in one package instead of two seperate printings and then colate by hand.
any help is needed as soon as possible please !

Any luck on creating a truly dymanic link with an Excel file in a Word document? The data that I have may have lines added or removed. (Same problem as David Robinson). Any idea of use of a range name to resolve? I’ll keep looking and post anything I find back here.

I knew it: as soon as I posted a query, I’d find an answer. Just incase this helps you too.
1) Name your range in Excel
2) Do all the stuff above that Diana says to do
3) In Word, In the Microsoft Office Button, click Prepare > Edit Links to files (or right-click on table and choose Linked Worksheet Object > Links…)
4) Edit your link: click Change Source.
-Click the button [Item...]
- Type in your range name and click OK
- click OK or accept (or whatever) to close all your dialog boxes.

Your linked table will now shrink or grow as your original Excel range shrinks or grows.

If you get really lucky, you might not even have to edit the link–just check that the Range name appears in the Item column of the Links dialog if you want to be sure.

I’m trying to link an excel page and a word document. The thing is I want to be able to check a checkbox in the excel page and have that link to a checkbox (non-activex) in the word document. This way I can check the checkbox in the excel page only, and it will check the one in the word document without me having to do anything to the word document…hope i made that halfway understandable. Any thoughts or ideas?