Question

You have an inventory chart in Excel that you would like to include in a Word budget document. You want to make sure that any changes made to the Excel chart are reflected in both the original Excel file and the Word document. What paste function should you use?

Answer 1

The paste function to use when you want to ensure that variations in an Excel chart from an Excel file (source) are updated on the Word document (target file) is the:

Link and Keep Source Formatting function.

Cheers!