Kasper Langmann, Co-founder of Spreadsheeto Inserting new Excel worksheets in Word Linking an Excel worksheet is the best way to get Excel data into Word, because Excel is the best tool for working with spreadsheets. The second is to insert a table.
To insert the Excel worksheet as a table in Word Open a Word document. To edit the embedded Excel worksheet again, double-click on the embedded object. Merge Data 1.
So those are all the different ways you can get an Excel spreadsheet into Word and have them linked or not linked, depending on your needs. Whether you embed or link, the inserted Excel spreadsheet will not automatically get updated unless you specifically create the link between the two files.
This time, click the Create from File tab. If you have any questions, feel free to comment.
If you make changes to the data in Word and save the file, you will get the same message above asking if you want to update the file from the linked files when you go to open the file again.
Linking to an Excel worksheet to Word document has a few limitations: If the Excel file is moved, the link to the Word document needs to be re-established. Fortunately, linking an Excel object in Microsoft Word is easy. Step 4: Click Yes and your table will reflect the new values.
How to Link Excel to Word in Exceland Linking an Excel file to a Word document ensures that the Word document is updated every time the data in the Excel file changes.