File Sharing Problems

How to Embed an Excel Dashboard from OneDrive Without Sign-In

Algirdas Jasaitis Oct 10, 2026 870 views

Question details

Users need to embed an Excel dashboard from OneDrive on a webpage so that visitors can view it anonymously without being prompted to sign in.

How to Embed an Excel Dashboard from OneDrive Without Sign-In

Product: Microsoft Excel / OneDrive
Device & OS: not provided
Scenario: Embedding an Excel dashboard for public or anonymous web viewing.
Observed behavior: Visitors are unexpectedly prompted to sign into a Microsoft account to view the embedded dashboard, blocking anonymous access.

Before you start

Ensure you know whether your file is stored in a OneDrive Personal account or a OneDrive for Business/SharePoint account, as the sharing settings and administrative controls differ significantly.

Solution 1Recommended

Generate an 'Anyone' Sharing Link in OneDrive

To allow anonymous access, the embed code must use a sharing link explicitly set to allow anyone to view the file without requiring a Microsoft account login.

By default, OneDrive for Business may generate links that are restricted to people within your organization. Modifying the sharing link permissions ensures public visitors can view the embedded dashboard.

Open sharing settings

Log into your OneDrive account on the web, locate your Excel dashboard file, click the 'Share' icon next to the file name, and open the link settings menu.

Set public permissions

Select the option that says 'Anyone with the link' and ensure the permission is set to 'Can view'. Click 'Apply' to save the changes.

Generate the embed code

Copy the newly generated sharing link and use it within your iframe HTML or web part embed code to replace the old restricted link on your website.

Test the embedded link

Open an incognito or private browsing window and navigate to your webpage to verify that the dashboard loads smoothly without a sign-in prompt.

Generate an 'Anyone' Sharing Link in OneDrive

Testing Tip: Using a private or incognito window is crucial, as it ignores your active Microsoft 365 login session and accurately simulates what a public visitor will experience.

Solution 2

Review Admin Policies for External Sharing

If the 'Anyone' link option is greyed out or missing, organization-level policies in SharePoint or Microsoft Entra ID are actively blocking anonymous sharing.

Share Spreadsheets Publicly with WPS Office

Avoid complex SharePoint admin settings and Microsoft Entra restrictions. WPS Office provides straightforward cloud sharing, allowing you to easily generate public links for your spreadsheets so anyone can view them without signing in.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open the dashboard file you wish to share publicly.
2. Access the Share menu: Click the 'Share' button located in the top right corner of the application window.
3. Set permissions to public: Change the sharing permission dropdown to 'Anyone with the link can view'.
4. Create and use your link: Click 'Create Link' to generate a public URL that can be shared or embedded anywhere without requiring visitors to sign in.

100% compatible with Microsoft Excel (.xlsx) formatsGenerate public sharing links with one clickNo complex administrator configurations requiredFree to download and use for essential spreadsheet tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why is the 'Anyone with the link' option greyed out in my OneDrive?

This usually happens because your organization's IT administrator has disabled anonymous external sharing. You will need to request that they open the SharePoint Admin Center, navigate to Policies > Sharing, and increase the sharing permission level to 'Anyone'.

Can I embed a workbook from a personal OneDrive account without sign-in?

Yes. In OneDrive Personal, you can easily generate a public embed code. Simply right-click the file in your web browser, select 'Embed', and click 'Generate'. The resulting HTML code natively allows public viewing without a sign-in prompt.

Why does my embedded dashboard work for me but prompt others to log in?

If it works for you, it is likely because your browser has an active, cached login session for your Microsoft account. Always test your embedded pages using a private or incognito browsing window to ensure the public link functions correctly for anonymous users.

Document & File Issues