Software

Ask something
Discussion Locked

Link Excel cells

0 helpful
7 replies

by yulista

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

How can I link a single Excel cell into MS Word table? The cells will come from various cells, sheets, and worksheets.

Thank you.

7 replies

by dklippert

Select the Excel entry and copy it. Go to the Word document and select the location. Now go to Edit>Paste Special Make sure the Link box is checked and choose Formatted Text (RTF).

by kees.valkenswaard

Paste Special, Paste Link is important. RTF is nice to maintain the Excel formatting. Plain text allows using Word Formatting. It depends on your application what is best. The link can be in a table cell. Alignment within the cell is the normal Wordprocedure. [Special fields are used for the link]

by yulista

If I selected the "Unacceptable" rating, I apologize, the answer was helpful, but here's the situation. The customer provided 48 eight pages of Word tables with 2 columns and at least 22 rows per page requesting pricing info in each column/row. We complete our calculations in Excel, and in this case we had 12 workbooks, using 8 different worksheets. So, altho the Paste Link was useful, The Word doc with the links took quite a while to update links and open. Thanks for your help.

This discussion is closed to new replies.