Ever need to insert an Excel worksheet into a Word document and have them linked so that when you update the main Excel worksheet, it automatically updates the one in the Word document?
There are actually two ways to insert an Excel object into Word, linking and embedding. When you embed an Excel worksheet, the worksheet will not be updated when you update the main Excel file.
When you insert a linked worksheet, whenever you open the Word file, the linked Excel sheet will update it’s values to match the main external Excel file.
0 comments:
Post a Comment