• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Working with Other Microsoft... > Storing an Excel Document as Part of...

Storing an Excel Document as Part of Another Office Document

In the preceding section of this chapter, you learned how to link to another file from within your Excel workbook. The advantages of linking to another file are that the size of your workbook is kept small and that any changes in the document to which you link will be reflected in your workbook. The disadvantage is that the linked document must be copied along with the workbook, or at least be on a network-accessible computer. If Excel can’t find or access the file where the link says it is located, Excel won’t be able to display it.

If file size isn’t an issue and you want to ensure that the other document will always be available, you can embed the file in your workbook. Embedding another file in an Excel workbook means that the entirety of the other file is saved as part of your workbook. Wherever your workbook goes, the embedded file goes along with it. Of course, this file is no longer connected to the original file, so changes in one aren’t reflected in the other.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint