Discussion Locked

Excell 2000 totals in word

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Can I import totals from Excell into word doc automatically.
We want to have spreadsheets with our different activities set out but just the totals need updated weekly or monthly into doc. We don't want to put the whole table in the doc.
Want we want to do is be able to add to the tables and have the totals automatically updated in the word doc.
Clear as mud I'm sure

7 replies

by ann - consider it done

Yes, you can import totals from Excel into a word document.

1st know the Excel cell address (i.e., A35) that contains the information you want in your word document.

2nd navigate to the location in the word document that you want the excel information to be

3rd from the Toolbar select INSERT / FILE

4th select the Excel file, click the RANGE button and identify the Excel cell address

5th click the small arrow to the right on the INSERT buttom, select INSERT AS LINK

by dklippert

An easy way to do it is to copy the cell in Excel.
Switch to Word. Place the insertion point where you would like the data.
Go to Edit>Paste Special.
Choose the Paste Link option and Formatted or UnFormatted text. Click OK and You now have a linked field.

by dklippert

Copy the cell in Excel.
Put your insertion point into Word where you want it, then go to the Edit menu and choose Paste Special. Choose the Paste Link option and either Formatted or Unformatted text.
There it is a linked field.

This discussion is closed to new replies.