Embed Folder in Excel File

[Shabbo]

Dear Sir,

Can we Embed folder in excel sheet as we do PDF filed embed using ----> Insert------>Object.

Also is there any way to Embed another excel file sheet in the excel sheet.

 

[sdsurzh]

1. To do it, you need to click on the Insert tab in the ribbon, and then click Object. This will open a dialog window allowing you to set the object to insert.
2. Click on the Create from file tab to insert your specific file.
3. Click Browse button and select the file you are looking to insert.
4. There are a few check-boxes for options. Link to file will put a reference to the file,
   so any edits made to the embedded workbook will be reflected on the original.
5. Display as icon will show an Excel icon with the name and location of the original file.
   Leaving this unchecked will embed the sheet itself within a floating, moveable and sizable window.

https://sebastian.expert/solved-add-attach-or-insert-file-in-microsoft-office-excel/

 

[Shabbo]

Dear Sir,
Thanks for your reply, but I wanted to Insert FOLDER and Excel File what you have shown is to Insert PDF documents etc.

 

[sdsurzh]

Hi Shabbo,

to my knowledge if you want to insert a folder you can use hyperlink. But through insert object option you can't.

Regards,
SK

 

[OdhranDriscoll]

This can only be done through a hyperlink as said sdsurzh. I tried to insert the image as you want, but nothing happened. only if you make the hyperlink, but it is not very convenient. another way I have not found. maybe somebody else knows a way.

 

[Maverick1]

You can add multiple files into excel as a folder, you will need to first zip the folder & follow the exact same process to embed/insert an object.