Hi, I'm looking to be able to connect a Word Table of Contents to Excel, the excel version should automatically update when the Word version does. Is this possible?
Hi, I'm looking to be able to connect a Word Table of Contents to Excel, the excel version should automatically update when the Word version does. Is this possible?
You want to copy what you want from Word, then paste as a linked object in Excel.
Copy in word.
from-Word.png
Switch to Excel and paste special as a LINKED Word document object.
xl-OLE-dialog.png
And it appears in Excel.
to-Excel.png
Then make changes in the Word document, and see if they show up in the Excel workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks