Fix a SharePoint Login Prompt for an Embedded Excel Workbook
Question details
The user needs other people to view an embedded Excel workbook without an unexpected SharePoint sign-in prompt.

- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- An Excel workbook stored in SharePoint or OneDrive for Business is embedded on a website for others to view.
- Observed behavior
- The workbook displays for its owner, but other visitors are prompted to sign in even though a viewing link has been shared.
Locate the original workbook in SharePoint or OneDrive for Business and confirm that you can manage its sharing settings and the website's embed code. Check whether the intended audience should have anonymous access or should sign in with an authorized account.
Check sharing permissions and recreate the embed code
Use this method to align the workbook's sharing settings and embed code with the intended audience.
In SharePoint or OneDrive for Business, select the workbook and choose Share. Open the link settings and check which people can access the file and whether they have viewing permission.
In the link settings, select Anyone with the link if it is available and anonymous access is intended. If a Require sign-in option appears, leave it unchecked; otherwise, use the available link settings to confirm whether sign-in is required.
Open the workbook in Excel for the web and look for File > Share > Embed, if available. Follow Microsoft's current SharePoint or OneDrive for Business embedding instructions, then replace the existing iframe code on the website with the generated code.
Open the website in a private or incognito browser window without signing in. Test the embedded workbook and, separately, the sharing link to see whether both work for the intended audience.

Test a new workbook to isolate the cause
Use a simple test file to determine whether the issue is specific to the original workbook or affects the embedding setup more broadly.
Work with Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility, making it easy to move your files. It does not change SharePoint permissions or fix an existing SharePoint embed.

Frequently Asked Questions
Why can I see the embedded workbook when visitors cannot?
You may already be signed in with an account that has access to the workbook. Open the page in a private browser window to check what an unsigned-in visitor sees.
Does a view-only sharing link guarantee that the embed will work anonymously?
No. The link may require sign-in, and the embed configuration or organization policies may impose different restrictions. Check Share > Link settings and test both the link and the embedded page in a private window.
What if the Anyone with the link option is unavailable?
Your organization or SharePoint site may restrict anonymous sharing. Ask your SharePoint administrator whether external or anonymous sharing can be enabled for the intended audience.
Where can I get a new Excel embed code?
Open the workbook in Excel for the web and look for File > Share > Embed. Availability depends on the workbook's location and your organization's settings; follow Microsoft's current embedding guidance for SharePoint or OneDrive for Business.




