Permission & Access Issues

Fix Embedded Excel Diagrams Prompting for Microsoft 365 Sign-In

Elise Williams Oct 10, 2026 868 views

Question details

Users embedding publicly shared Excel diagrams in an iframe are experiencing unexpected authentication prompts, preventing anonymous public viewing.

How to Embed Excel Diagrams Without a Microsoft 365 Sign-In Prompt

Product: Microsoft Excel / SharePoint
Device & OS: not provided
Scenario: Displaying publicly shared Excel diagrams via an iframe on a public display or dashboard.
Observed behavior: The embedded iframe prompts visitors for a Microsoft 365 sign-in, even though the file itself was shared using a public link setting.

Before you start

Ensure you have administrative access to your Microsoft 365 or SharePoint admin center, as resolving this requires checking and modifying tenant-level sharing policies.

Solution 1Recommended

Verify Organization and Site-Level Sharing Policies

Use this solution to ensure that your Microsoft 365 and SharePoint administrator settings allow for true anonymous access, which is required for public iframes to work without authentication.

Even if a specific Excel file is set to 'Anyone with the link can view', Microsoft 365 organization policies can override this at a higher level, blocking anonymous access and forcing a sign-in prompt.

Access SharePoint Admin Center

Check Organization Sharing Settings

Go to 'Policies' and then select 'Sharing'. Ensure that the external sharing slider for both SharePoint and OneDrive is set to 'Anyone' (the most permissive option) to allow anonymous guest links.

Verify Site-Level Settings

Navigate to 'Sites' > 'Active sites' in the admin center. Select the specific site where the Excel file is hosted, click 'Settings', and verify that the external sharing setting for that specific site is also set to allow 'Anyone' links.

Verify Organization and Site-Level Sharing Policies

Policy Propagation Time: After changing organization or site-level sharing policies, it may take several hours for the changes to fully propagate across the tenant.

Solution 2

Use Alternative Anonymous Publishing Methods

If admin policies cannot be changed due to security rules, use dedicated publishing tools designed for public embedding rather than relying on standard sharing links.

Solution 3

Contact Microsoft 365 Support

If all policies appear correct but the iframe still demands authentication, reach out to Microsoft Support to investigate backend tenant configurations.

Free Microsoft Office alternative

Try WPS Office for Hassle-Free Document Sharing

If strict Microsoft 365 sharing policies are blocking your public dashboards, consider switching to WPS Office. It provides an intuitive, lightweight, and free alternative to Microsoft Office, complete with seamless format compatibility and straightforward public link generation without the need for complex admin tenant configurations.

1. Open Your Spreadsheet: Launch WPS Office and open the spreadsheet you want to share.
2. Create a Public Link: Click the 'Share' button in the top right corner and select 'Anyone with the link can view'.
3. Embed or Share: Copy the generated link and use it in your dashboard or iframe setup for seamless public viewing.

100% compatible with Microsoft Excel (.xlsx) formatsEasily generate public viewing links without complex tenant admin restrictionsFree, lightweight, and easy to use on multiple operating systemsFamiliar user interface ensuring a seamless migration from Microsoft Office

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel iframe ask for a password when the link is set to public?

This happens when your organization's overarching Microsoft 365 or SharePoint administrator policies restrict anonymous access. These organization-level settings will override individual file permissions, forcing a sign-in prompt to ensure data security.

Can I keep a business account permanently signed in on a display screen like a Raspberry Pi?

While possible, it is not recommended for security and reliability reasons. Session timeouts, mandatory password resets, and multi-factor authentication (MFA) will frequently log the account out. It is better to use a supported anonymous publishing method.

How do I check if anonymous access is blocked on my SharePoint site?

You need SharePoint Administrator permissions. Go to the SharePoint Admin Center, select your site under 'Active sites', click 'Settings', and check the 'External file sharing' options. If 'Anyone' is greyed out or not selected, anonymous access is blocked.

Document & File Issues