![]() 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.Įmbedding a document, on the other hand, increases the size of your Word document, because all that Excel data is actually embedded into the Word file. If it doesn’t, you’ll have to link it again. ![]() One disadvantage is that the original spreadsheet file needs to stay in the same location. There are advantages to both methods, of course. 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. Updating the original Excel sheet does not automatically update the data in the target document. If you embed an Excel worksheet in a document, that connection is broken.If you update the Excel file, those updates get automatically reflected in the target document. If you link an Excel worksheet in a document, the target document and the original Excel sheet maintain a connection.The difference comes in how these two options treat their connection to that original Excel spreadsheet: It will look like an Excel sheet, and you can use Excel’s tools to manipulate it. Both are pretty similar, in that you end up inserting an actual Excel spreadsheet in your target document. While that can be useful sometimes, your other two options-linking and embedding-are much more powerful, and are what we’re going to show you how to do in this article. For the most part, this only works with really simple data because that data just becomes a basic table or set of columns in Word (depending on the paste option you choose). The first is by simply copying that data from the spreadsheet, and then pasting it into the target document. You actually have three options for including a spreadsheet in a Word document. What’s the Difference Between Linking and Embedding?
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |