Cannot embed spreadsheet to Website

Question

I had an excel spreadsheet that was embedded on my company's website for a while, but it would seem that the link expired or something. We're using One Drive for business.

"https://support.office.com/en-us/article/embed-your-excel-workbook-on-your-web-page-or-blog-from-sharepoint-or-onedrive-for-business-7af74ce6-e8a0-48ac-ba3b-a1dd627b7773?ui=en-US&rs=en-US&ad=US"

I followed the instructions above to try and get the spreadsheet back on the website, but it is outdated and the instructions do not match the ever changing 365 layout. So there are buttons or links that I could not reach.

The issue I am having is that external users need to be able to enter data in the spreadsheet so it can help them calculate their retirement, but when users come to the website, the embedded spreadsheet  requires them to log into Sharepoint. I can no longer embed something with the phrase "guest access" included with the link because the link that is generated by 365 does not include that. 

Did Microsoft remove this feature?

Below is how 365 used to embed the frame and this is exactly what I need, but there is no way to generate that.

"<iframe width="1150" height="640" frameborder="0" scrolling="no" src='https://my.sharepoint.com/personal/Username/_layouts/15/guestaccess.aspx?xx" 

Below is an example of what is generated now.

" <iframe width="402" height="346" frameborder="0" scrolling="no" src="https://my.sharepoint.com/personal/username/_layouts/15/xx" 

Can users no longer grant guest access for external users to use embedded content? They need to be able to interact with the spreadsheet as well. Please help!

Answer 1

I had the  calculator spreadsheet embedded on the website for external users to interact with the calculator. Anyone visiting the website was able to interact with the calculator, but then I think the link to embed the code created by the Web app, expired and the Calculator was no longer accessible. So what I then tried to do was recreate another link to embed it again, but now said embedded spreadsheet requires anyone visiting our website to sign in to Sharepoint. The embedded spreadsheet needs to have guest access and allow interactivity to all external users that navigate to our website.

Answer 2

Hi Mtorres,

How do you use the Excel Web App for the external users? Could you list the detailed reproducing steps of the issue you are experiencing now?

Thanks,

Cliff

Answer 3

Hello Cliff,

Unfortunately this does not solve my problem because users should not be able to edit and save data. The Spreadsheet acts as a Calculator and it has rules behind it that allow users to calculate their individual retirement. This requires them to plug in numbers temporarily. The way I had it embedded on the website, users could use the calculator without having to log into SharePoint and without being able to save changes to the spreadsheet. I want to hopefully be able to do this again since it was once possible.

Answer 4

Hi Mtorres,

Please let us know your updates at your convenience if you need further help on this issue.

Thanks,

Cliff

Answer 5

Hi Mtorres,

As the guest link has changed, there may be some trouble for you to embed the spreadsheet on a site page in SharePoint Online for external users.

In this situation, I suggest you use the Excel Web App. You can save the spreadsheet in a site library and give the external users unique permissions on the file level. Then you can embed the spreadsheet by using the Excel Web App and grant the external users the unique permissions on the page level. With the settings, the external users can navigate the page via the page URL and then open the embedded spreadsheet in Excel Online to edit it and sync the changes to the site page.

For your reference: Display Excel content in an Excel Web Access Web Part

Thanks,

Cliff