Sharepoint login shows instead of embedded Excel spreadsheet in a website.

Question

Hi.

I am attempting to embed an Excel spreadsheet into a website. I have used the 'embed' function found in the online version of the Excel spreadsheet and generated the required embed code (see below);

I have placed this into my website, but when I try to view the page on another computer or via incognito mode I get a screen stating SharePoint Login (see below);

I have checked for solutions online, and the most common solution is to ensure that any sign in required options are disabled. When I open the Embed screen there is no tick box for require sign in. I have checked the settings in the SharePoint Admin centre and the option to share without sign in is set (see below);

I am now at a loss as to what to do.

Any help would be appreciated.

Thanks.

Answer 1

"Anyone with the link can edit" only works if your organization allows anonymous access. Most don't for obvious security reasons, and Msft's language about this type of link is as usual confusing. Does the link work in an incognito window with no user signed in at all? If so, and you've also tried the file viewer web part, it's likely Msft is blocking the content from being iframed.

Hi webbrewers

I have tried a couple of workbooks and they both show up as expected in incognito browser windows. The iframe content shows correctly when I am logged in to my site (Wordpress), but when I am not logged in as an administrator then the iframe content does not show.

I will escalate this to support to see if they have a solution.

Thanks

Darren