File Sharing Problems

Embed an Excel Workbook on a Website Without Sign-In

Huma Ashraf ChHuma Ashraf Ch Nov 22, 2026 868 views

Question details

The user wants to display an Excel workbook on a public webpage without requiring visitors to sign in.

Product
Excel for the web and OneDrive for Business
Device & OS
not provided
Scenario
A workbook stored online needs to be embedded on an external public website for visitors to view.
Observed behavior
A standard embed URL may redirect visitors to a Microsoft sign-in page instead of displaying the workbook.
Before you start

Upload the workbook to OneDrive for Business and check whether your organization permits anonymous sharing. Make sure the workbook contains only information intended for public viewing.

Solution 1Recommended

Embed the workbook with public view permissions

Use Excel for the web to generate an embed code and allow anonymous viewing where your organization's settings support it.

1
Open the workbook online

In OneDrive for Business, select the uploaded workbook to open it in Excel for the web.

2
Create a view-only link

Select Share, open Link settings, and choose Anyone with the link if available. Turn off editing or select Can view, then apply the settings and copy the link.

3
Generate the embed code

In Excel for the web, select File > Share > Embed if the option is available. Copy the generated iframe code and paste it into the HTML of your webpage.

4
Test public access

Publish the page and open it in a private browsing window while signed out of Microsoft. Confirm that the workbook appears without a sign-in prompt.

Embed the workbook with public view permissions
Embedding depends on account settings: A public sharing link does not always work as a replacement for the iframe's generated URL. If embedding is unavailable or still requires sign-in, check your organization's OneDrive and SharePoint sharing policies with an administrator.
Free Microsoft Office alternative

Prepare Your Workbook with WPS Office

WPS Office is a free, lightweight, easy-to-use alternative for creating and editing spreadsheets in a familiar interface. Its Excel format compatibility helps you move workbooks between WPS and Microsoft Office, although OneDrive embedding and anonymous sharing remain subject to Microsoft settings.

Edit the workbook before publishing it to your websiteOpen and save Microsoft Excel XLSX filesWork in a familiar spreadsheet interfaceUse a free, lightweight office suite for everyday documents
microsoft office alternative - wps office

Frequently Asked Questions

Why does my embedded workbook ask visitors to sign in?

The workbook or its hosting service may require authenticated access. Check Share > Link settings for an Anyone with the link option, and ask your administrator whether anonymous sharing and embedding are allowed.

What if I cannot find File > Share > Embed in Excel for the web?

The Embed option may not be available for your account or organization's configuration. Check with your administrator, or use Share to create a view-only link if anonymous sharing is permitted.

Can I replace the iframe URL with a public sharing link?

Not every sharing link is a valid embed URL. Use the code generated by Excel for the web and test it while signed out; a view-only sharing link can also be placed on the page as a regular link.

How can I verify that visitors do not need a Microsoft account?

Open the published webpage in a private browsing window while signed out. If the workbook prompts you to sign in, review its sharing permissions and your organization's policies.