Forum Discussion
Embed Excel Workbook From SharePoint
I'm experiencing the same problem too. Here is my iframe embed code:
<iframe frameborder="0" scrolling="no" width="1300px" height="800px" src=" https://appriver3651017602-my.sharepoint.com/personal/anthea_crowinsight_com/_layouts/15/guestaccess.aspx?docid=1b17dabec9a1f49b187468da6ff7a95b3&authkey=AZFtRXQsUx8qGA3lwZ_LvhU&action=embedview&wdDownloadButton=True&wdbipreview=True&wdAllowInteractivity=True&wdHideHeaders=True&wdHideSheetTabs=True&wdHideGridlines=True&ActiveCell=O22">
I am able to embed the file, but you can see that the parameters are not taking effect. I have Office 365 ProPlus and OneDrive for Business. The Excel workbook I'm trying to embed in the code above is stored on my OneDrive account, and I'm using the parameters detailed on this Office Support site. I have also just activated SharePoint Online for my account and tried embedding with a new shared link, but the parameters are still not working.
Does this have something to do with the level of SharePoint access/support allowed in my subscription?
Hi Folks,
I have been able to test this and from the Fiddler analysis it looks like the request is redirected and the embedded code is stripped off. This may be a ticket to Microsoft.
Regards,
Pramod
- DeletedFeb 21, 2017
Hi everyone,
I believe I've found out what the issue is. I found an example workbook on this website that has an embedded Excel workbook with parameters working. Upon inspecting the code I realized that the workbook URL is from onedrive.live, NOT Sharepoint.
I then tested my own workbook by logging in to my Microsoft OneDrive account (i.e. the Microsoft account that is separate from O365 for business. I accessed OneDrive by going through onedrive.live.com, and not office.com). When I uploaded my Excel workbook to onedrive.live, selecting the workbook there brings up an embed code icon. I used the URL in that code and modified the parameters to generate this example:
<iframe frameborder="0" scrolling="no" width="1300px" height="800px" src=" https://onedrive.live.com/embed?cid=42E3AD426E37D95C&resid=42E3AD426E37D95C%21128&authkey=AHX-n7u6UUOimCw&em=2&action=embedview&wdDownloadButton=True&wdbipreview=True&wdAllowInteractivity=True&wdHideHeaders=True&wdHideSheetTabs=True&wdHideGridlines=True&ActiveCell=B5"></iframe>
I'm not sure if Sharepoint is supposed to have this feature enabled, and it seems odd that it doesn't. I don't know how to raise this as a ticket to Microsoft without having to pay to submit one, but I hope posting this here helps someone. Good luck!
- Asish PadhyFeb 22, 2017Brass Contributor
Hi,
If it is a Office 365 subscription, then there is Support button in the new Admin center. Give a brief three to two keyboards, to look for solutions and then submit the request.
Thanks,
Asish