As soon as you insert and object in an excel, its connection to the source file is lost, so make sure to do all required changes to the original file before embedding it however, you can also update the embedded file’s content by double-clicking the file icon or embedded content.NOTE: If you intend to print your Worksheet, then it is recommended to display the content of the Embedded file as it will not print the Embedded File’s content if the only icon is displayed. Make sure to select the “Display as icon” checkbox to display only the embedded file’s icon else, the file content will be shown in the worksheet, which takes more space and not recommended for presentation purpose.You can see the list of file types accepted by going to Insert > Text > Object > Create New > Object Type. You can only embed certain file types into an Excel Worksheet.Things to Remember about Inserting Object in Excel Embedded files are the preferred option compared to link to file option when you need to send the Worksheet to someone working on a different computer/ laptop since the link to file will only work if the source file is saved on the same device as the worksheet itself since Embedded files are saved within the Excel file. Embedded files keep the worksheet presentation limited to required data only, and any extra comments, notes, or information can be kept within the Embedded file, which allows users to focus on the key information and other information can be seen on need the only basis by accessing the Embedded file.Ĥ. When you double click the link, the source file will open.ģ. When you insert an object to an Excel worksheet, the object becomes part of the Excel file, and any changes made to the source file do not impact the embedded file however you may want to keep the file separate from your Excel file in that case, you need to check the “Link to file” option.Ī linked file is just a link to the source file, which can be edited only by editing the source file. You can double click on the embedded file icon or content to edit the content of the embedded file. NOTE: If you do not check the “Display as icon” option, the embedded file’s content will be shown instead of the icon. Step 3: Now click the OK, your file icon will be displayed in the worksheet. Remember, only file types are shown in “Object Type” that can be embedded in the excel worksheet. Step 2: Select Create from File and click Browse to embed an existing file to the worksheet. Step 1: Select Text from the Insert tab and then click Object. #2 – Embedding (inserting) an Existing Object in Excel Now choose a file type you want to embed for example, I have selected a Microsoft word file, now click OK.Select Create New to embed a new blank file.
Select Text from the Insert tab and then click Object.