When you insert an excel file into a word document the data are?
Answers
Answered by
1
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 values in the Word document also?
Well, there are actually a couple of ways to insert an Excel spreadsheet into Word: linking, embedding and creating a new one. Whether you embed or link, the inserted Excel spreadsheet will not automatically get updated unless you specifically create the link between the two files.
Once linked, however, then the data in the embedded or linked spreadsheet will update whenever changes are detected in the originating Excel spreadsheet.
In addition to inserting an existing Excel spreadsheet, you can also insert a new Excel object into Word, which basically runs Excel inside of Word itself.
usually three methods are there
1. copy paste method
2. insert object method
3. insert table method
Well, there are actually a couple of ways to insert an Excel spreadsheet into Word: linking, embedding and creating a new one. Whether you embed or link, the inserted Excel spreadsheet will not automatically get updated unless you specifically create the link between the two files.
Once linked, however, then the data in the embedded or linked spreadsheet will update whenever changes are detected in the originating Excel spreadsheet.
In addition to inserting an existing Excel spreadsheet, you can also insert a new Excel object into Word, which basically runs Excel inside of Word itself.
usually three methods are there
1. copy paste method
2. insert object method
3. insert table method
Similar questions