Which of the following integration methods should you use if each sales manager has access to the source workbook, has permission to change its contents, and is asked to update the source workbook with their latest estimates using the worksheet object in the sales report?

Question

Quizplus · Accepted Answer

Linking is the best choice in this scenario because it allows the sales managers to update the source workbook with their latest estimates using the worksheet object in the sales report. This ensures that the source workbook is always up-to-date and eliminates the need for manual updating. Copy and paste, Embedding, and Attaching are not suitable because they do not allow for updates to be made directly in the source workbook.

Which of the Following Integration Methods Should You Use If