Show part of a word document in an excel cell(s)

Topic

New Reply

I have an area of a word doc that I’d like to display in Excel. Updating would only happen in word. The data could probably be put in a table and then display in multiple cells in Excel too. Any ideas? The only thing I can find is how to insert the entire document.

Reply | Quote

Replies

Hi

If you set up a table in your Word Document, then copy that Table, got to Excel and choose Paste Special > Microsoft Word Object > and select Paste Link

Regards
Roger Govier
Microsoft Excel MVP

Reply | Quote

Weird. I’d tried that before using the paste icon dropdown and special wasn’t there, but with a right click in the cell it is!

Reply | Quote

Hi

Yes that is the case when you are posting between applications.
You will only see that option in the right click menu.
I should have made that clear

Reply | Quote