How to embed an Excel worksheet on OneDrive into a Webpage?

Hi. First post. Using Office (Personal version), I could go to my OneDrive, open an Excel file stored there, and choose "EMBED" to have it appear on my website.

I've recently switched to MS 365 for Business (non-profit) and transferred my Excel files to my "new" OneDrive. I can't find an Embed button for the files. After researching a bit, it appears that Sharepoint is required now? I know nothing about Sharepoint and am hoping for some guidance.

1. Is Sharepoint required to embed a file on a website using MS 365 for Business?

2. If so, what's the best way to go about learning how to do this? The help I've found indicates to go to Sharepoint and "right click the file you want to embed and click 'embed'", but, of course, my files don't show up on Sharepoint.

I hope I've worded this properly. Any help appreciated. Thanks.

Hi,

Have you already found this doc ?

https://support.microsoft.com/en-us/...b-a1dd627b7773

You are not alone

https://techcommunity.microsoft.com/...ess/m-p/167506

Thanks so much for the reply. Yes, I had found your first link, the one that explains how to do it using Sharepoint. Your second link was helpful in that it allowed me see how to open the file to embed, then click File>Share>Embed.

I thought that would do it but when the embed window opened, the "What do show" portion was blank (spinning circle) and when I went ahead and copied/pasted the code into my website, all it shows is a Sharepoint logo with a signing button.

So, apparently, something with Sharepoint is required in order to embed my Excel file (stored on OneDrive for Business) to my website.

Any other ideas appreciated. Thanks again.

ASAC said:

Thanks so much for the reply. Yes, I had found your first link, the one that explains how to do it using Sharepoint. Your second link was helpful in that it allowed me see how to open the file to embed, then click File>Share>Embed.

I thought that would do it but when the embed window opened, the "What do show" portion was blank (spinning circle) and when I went ahead and copied/pasted the code into my website, all it shows is a Sharepoint logo with a signing button.

So, apparently, something with Sharepoint is required in order to embed my Excel file (stored on OneDrive for Business) to my website.

Any other ideas appreciated. Thanks again.

Verify your sharing permission in Sharepoint, The workbook must have "Everyone" mentioned in the list.

MaloK said:

Verify your sharing permission in Sharepoint, The workbook must have "Everyone" mentioned in the list.

Yes, I've read a bit about that and sense that that is what I need to do. However, I have no experience in SharePoint and when I open it I'm not sure what to do. There is nothing there, no files, no pages, no "sites", etc. so there's no file/workbook to share a permission to "Everyone".

If it's easy, would you mind walking me through what to do once I get to Sharepoint? If not, can you shoot me a link that will help me get started in Sharepoint? Thanks, all.

ASAC said:

Yes, I've read a bit about that and sense that that is what I need to do. However, I have no experience in SharePoint and when I open it I'm not sure what to do. There is nothing there, no files, no pages, no "sites", etc. so there's no file/workbook to share a permission to "Everyone".

If it's easy, would you mind walking me through what to do once I get to Sharepoint? If not, can you shoot me a link that will help me get started in Sharepoint? Thanks, all.

It;s very hard to give a simple walk trough for me with your version of SharePoint...
But, the steps are as following.

Share a site
Create a workplace
Publish a document to the workplace
Share the document
Set security on the document
Publish in an embedded page
Adjust Frame size and layout.

I'm running SharePoint Server 2013 so the steps I take are probably irrelevant for you.

A quick update. I've been on the phone with Microsoft twice in the last week for a total of around 3 1/2 hours. It's taken a lot of tweaking, even had to use Powershell, to get the correct permissions set so that I could change other permissions that allowed me to set still other permissions to allow the ability to Share files on OneDrive linked to Sharepoint with "everyone" when embedded on a webpage.

It's still not working.

In Sharepoint, I can go through all the steps to make the file shareable/viewable on a webpage. In OneDrive, I can click File>Share>Embed and everything looks normal. I paste the code and publish the webpage and instead of the file contents a "Sign into Sharepoint" graphic is seen.

Will talk to MS again in two days. I am amazed at how difficult this has been. The process is so simple in the Personal version of Microsoft 365 and just ridiculous in the Business version.

Thanks, Malok, for the help, and I will let you know how it comes out.