Updating access spreadsheet
One advantage of linking a document (other than maintaining the connection) is that it keeps your Word document’s file size down, because the data is mostly still stored in the Excel sheet and only displayed in Word.One disadvantage is that the original spreadsheet file needs to stay in the same location. And since it relies on the link to the original spreadsheet, it’s not so useful if you need to distribute the document to people who don’t have access to that location.
If you would like to link or embed the entire worksheet, click on the box at the juncture of the rows and columns in the top left-hand corner to select the whole sheet.
Now, switch to your Word document and click to place the insertion point where you would like the linked or embedded material to go.
On Home tab of the Ribbon, click the down arrow beneath the “Paste” button, and then choose the “Paste Special” command from the dropdown menu. And it’s here where you’ll find the only functional different in the processes of linking or embedding a file. Whichever option you choose, you’ll next select the “Microsoft Excel Worksheet Object” in the box to the right, and then click the “OK” button.
This information helps you to identify the best approach for your business case.
You must generate the spreadsheet from a spreadsheet template. To create templates, you can either copy a predefined template and edit it or create a template from scratch.