This article explains how to embed an existing Excel Workbook as an object into Ms Word: https://helpdeskgeek.com/office-tips/embed-an-excel-worksheet-into-word/
I have a workbook with multiple worksheets/tabs. I am using Office 365 with the Office 2016 suite installed.
I would like to:
- Embed two worksheets from the same workbook in 2 different places into my Word doc
- Optionally limit the cells from the worksheets that are embedded to a specific range.
- Use the "Link to File" option to ensure the worksheets are updated when the source excel file is updated.
Both the Excel doc and the Word doc are stored in Sharepoint 365.
Are there any techniques for achieving these requirements?