Forum Discussion
Embed Excel Workbook From SharePoint
Hi Karan,
I've been tinkering around with this and I've sort of found a way to make it work. I think Microsoft has been making updates and changes also, as the embed options are different than from when I posted in this forum a few months ago. This makes it quite hard to keep up with what works/doesn't work. But for now, my workaround seems to work.
After you've set sharing to "Everyone", click "Get link." The link that I get looks something like this: "https://hostprovidername-my.sharepoint.com/personal/myname/....guestaccess.aspx?docid=23kj4hkjbs876...&authkey=SIdslbxxoIL2jd8s"
Switch out "guestaccess" with "WopiFrame", and try the embed again. It should be available to the public now and parameters will work.
There's a different docid that is generated if you get the pre-generated embed code. It defaults to WopiFrame.aspx, but the query after it will look like this: "WopiFrame.aspx?sourcedoc={3jf890d-0s9d-298d-d9x0-9d9s87c7shdf}" This will not allow public access without signing in.
Hope this helps!
P.S. a neat parameter I discovered via the embed code options box is that you can set the default active cell. Param is ActiveCell='Sheet1'!A1
I ran into this issue and found this post. Not sure about permissions as I tried several things before I finally got something to work. No idea where the embed icon is on the business side of sharepoint/onedrive, but when I opened it up in Excel Online, I just selected the icon at the end of the ribbon called "Tell me what you want to do." I typed in Embed and it took me to the typical embed prompt I saw on the consumer side. I got it embedded in an external website and it looks to be working.
- Thanks for this tip! Spent a good amount of time looking for Excel embed options for use on a SharePoint site and this provided the best solution. Used the Embed web part to display the selected range.
