Question

You have a sales chart and excel that you want to include in a 3rd quarter report to include in a 3rd quarter report quit it in word you want to make sure the data in the you want to make sure the data in the chart continues to show only 3rd quarter results in the world the 3rd quarter results in the word document after the excel cell's data is updated sales data is updated with the 4th quarter information what pay function should you use

Answer 1

The paste function to use is the Advanced Paste Function that reads Use Destination Theme and Link Data or Keep Source Formatting and Link Data.

Step-by-step explanation:

The first function adopts the Theme (such as colors, fonts, and other formatting) whilst retaining links to the data in the excel workbook. The latter imports the formatting or theme as-is from excel.

In both scenarios, (for as long as both documents are open and are in the same file) when the data in excel is opened and updated, it reflects automatically in the chart on the Microsoft Word document.

Cheers