Embedded workbook frame

Question

Hello everyone hoping you're having a nice day. I recently made an Excel for making class schedule that pulls data from an Excel database I got from the school. I want to share it with some of my friend so I'm planning to simply embed it onto a Github page with this method. There're some questions that I have:

1. Is there anyway to hide that Excel 'frame'? I want to keep the download option but there seems to be no flag to hide the frame.
2. According to this tutorial by Microsoft, there's an option to hide that frame if I use SharePoint or OneDrive for Business. Does my school account count? I can't even finish the first "Make the workbook public" step.

Thank you all!

Answer 1

Hi Tuan,

You first, need to upload the workbook to OneDrive or SharePoint library. Then open the workbook in Excel for the Web > File tab > Share > Embed

****![Image](https://learn-attachment.microsoft.com/api/attachments/635264e8-955a-4eb6-bd5f-5c390ef1ed2c?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/f473fd58-bb7d-4c2b-b86a-f7748f85c790?platform=QnA" rel="ugc nofollow">

For example:

<iframe width="402" height="346" frameborder="0" scrolling="no" src="https://mXXXXXXXX.sharepoint.com/sites/ModernTeamSite1/_layouts/15/Doc.aspx?sourcedoc={SXXXXXXXXXX}&action=embedview&wdAllowInteractivity=False&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True&wdInConfigurator=True"></iframe>

Then go back to the OneDrive for SharePoint library > select the workbook > share > anyone with the link > set can view or can edit > apply > copy

 

Note: if you see “anyone with the link” button is greyed out, generally it can happen to SharePoint site, you need your SharePoint admin help, go to SharePoint Admin Center > Active sites > select the SharePoint site > Policies > External Sharing > Edit > Select External Sharing site content can be shared with Anyone.

Then you use the anyone link replace the original file URL in the embed code.

<iframe width="402" height="346" frameborder="0" scrolling="no" src="anyonnelink}&action=embedview&wdAllowInteractivity=False&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True&wdInConfigurator=True"></iframe>

For the frame hide, do you mean the whole black bar of the frame? There’s no settings to hide. The article you find is to only hide sheet tabs or show/hide download icon.

Regards,

Rena

Answer 2

Hello, Tuan

Haven't heard from you for a while. Do you have other concerns about this issue? If you need further support, just reply and we will proceed to support.

Best regards

Igor

Answer 3

Hi Tuan,

In case you have inserted the links to other worksheets/workbooks in your embedded Excel file the others would not be able to open them. You will need to grant the access to the linked workbooks.

Regards,

Igor

Answer 4

Thank you for your reply.

I understand. Just a follow-up: some functions in my embedded worksheet have links to data elsewhere, say, in another worksheet in the workbook or even another workbook in the same OneDrive folder as the embedded workbook. Would it work for other people if they interact with the embedded worksheet?

Thank you!