Permission & Access Issues

Fix a SharePoint Login Prompt for an Embedded Excel Workbook

Steven ParkerSteven Parker Nov 20, 2026 868 views

Question details

The user needs other people to view an embedded Excel workbook without an unexpected SharePoint sign-in prompt.

Fix a SharePoint Login Prompt for an Embedded Excel Workbook
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.
Before you start

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.

Solution 1Recommended

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.

1
Review the workbook's sharing settings

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.

2
Allow anonymous viewing if appropriate

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.

3
Generate a fresh embed code

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.

4
Test as a visitor

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.

Check sharing permissions and recreate the embed code
Organization policies may require sign-in: An administrator can restrict anonymous sharing or embedding. Even when an Anyone link is available, anonymous viewing may not be supported for every embed configuration. If the required option is unavailable or the embed still prompts for sign-in, contact your SharePoint administrator.
Free Microsoft Office alternative

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.

Open and edit Excel spreadsheets in a familiar interfaceCompatible with Microsoft Excel formats such as XLSX and XLSLightweight tools for working with spreadsheets and other Office filesFree to download and easy to use when moving from Microsoft Office
microsoft office alternative - wps office

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.