Permission & Access Issues

Fix Embedded Excel File Prompting for Sign-In on Public Websites

Maira Mehtab Sep 28, 2026 869 views

Question details

An embedded Excel workbook on a WordPress website is requesting user authentication, despite the sharing permission being explicitly set to "Anyone".

Product: Microsoft Excel
Device & OS: not provided
Scenario: A user embedded a Microsoft Excel file on a public WordPress website aiming for anonymous public viewing.
Observed behavior: Instead of displaying the spreadsheet directly, the embedded frame prompts website visitors to sign in to a Microsoft account.

Before you start

Ensure you have access to the original Excel file on OneDrive or SharePoint, and can edit the HTML embed code on your WordPress website.

Solution 1Recommended

Verify and Re-generate the Anonymous Embed Code

Use this solution to ensure your embed code is accurately tied to a working anonymous sharing link, which is the most common cause of sign-in prompts.

Sometimes, the embed code is generated using a restricted sharing link rather than an "Anyone" link. Regenerating the link and replacing the code usually resolves the authentication issue.

Open File Sharing Settings

Locate your Excel file in OneDrive or SharePoint online, click the Share icon, and select 'Share'.

Set Permissions to Anyone

Click the link settings (usually labeled 'People in your organization' or similar) and change it to 'Anyone with the link'. Apply the settings.

Generate the Embed Code

Open the Excel file in Excel for the Web, go to File > Share > Embed, and copy the provided HTML embed code.

Update Your Website

Log into your WordPress dashboard, navigate to the specific page, and replace the old HTML embed code with the newly generated one.

Link Verification: Before pasting the embed code, test the raw sharing link in an Incognito window to confirm it opens without asking for credentials.

Solution 2

Clear Browser Cache and Check Cached Credentials

Use this method to rule out local browser conflicts where outdated cached credentials force an unnecessary sign-in prompt.

Solution 3

Investigate Tenant Restrictions (Microsoft 365 Admins)

If you are using a business account, use this solution to verify that your organization's IT policies allow anonymous sharing.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If Microsoft 365 tenant restrictions are preventing you from smoothly sharing files, consider WPS Office. It offers a free, lightweight suite with complete compatibility for Excel files and hassle-free document management.

1. Download the App: Download and install WPS Office for free from the official website.
2. Open Your Spreadsheets: Open your existing .xlsx files directly in WPS Spreadsheets with full formatting retained.
3. Share with Ease: Save your documents to WPS Cloud for streamlined sharing and collaboration.

Highly compatible with Microsoft Excel (.xlsx, .xls) formatsFree to use without complex business tenant restrictionsLightweight application with a familiar, tabbed user interfaceSeamless local file management and accessible cloud saving features

microsoft office alternative - wps office

Frequently Asked Questions

Why does my "Anyone" sharing link suddenly stop working?

Microsoft 365 administrators can set an automatic expiration policy on anonymous links (e.g., links expire after 30 days). Once the link expires, the embedded file will display an error or a sign-in prompt.

Does embedding an Excel file expose my other OneDrive files?

No. When you generate an embed code for a specific workbook using a secure 'Anyone' link, visitors can only view that specific file. They do not gain access to the rest of your OneDrive or SharePoint directory.

Can I hide the bottom toolbar on my embedded Excel file?

Yes. When generating the embed code in Excel for the Web, you can customize the appearance by unchecking 'Include download button' or 'Show gridlines', which modifies the embed parameters in the HTML code.

Document & File Issues