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


  1. Posts : 4
    Mac OS 11.6
       #1

    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.
      My Computer

  2. MaloK's Avatar
    Posts : 974
    Windows 7
       #2
      My Computer


  3. Posts : 4
    Mac OS 11.6
    Thread Starter
       #3

    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.
      My Computer

  4. MaloK's Avatar
    Posts : 974
    Windows 7
       #4

    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.
      My Computer


  5. Posts : 4
    Mac OS 11.6
    Thread Starter
       #5

    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.
      My Computer

  6. MaloK's Avatar
    Posts : 974
    Windows 7
       #6

    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.
      My Computer



  7. Posts : 4
    Mac OS 11.6
    Thread Starter
       #7

    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.
      My Computer

  8. Berton's Avatar
    Posts : 11,956
    Win10 Pro Versions 2004 and 2009/20H2, Win10 Pro IP_Dev, Win10 Home 1909
       #8

    Don't know if it will work in your situation but I kinda cheated in posting a membership list on my Domain using Excel and Publish as HTML. That page is linked from the main page. Then for a few of the members I loaded that same Excel spreadsheet onto the Domain and put a link to it on the membership page for folks to download and save.
      My Computers


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 02:31.
Find Us




Windows 10 Forums