'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Embed an Excel Spreadsheet Without Requiring Sign-In
Question details
The user wants to embed an Excel spreadsheet on a public website so visitors can view it without needing to authenticate or sign in to a Microsoft account.
- Product
- Microsoft Excel (OneDrive / SharePoint)
- Device & OS
- not provided
- Scenario
- Embedding an Excel file via an iframe on a website for public, anonymous visitors.
- Observed behavior
- Website visitors are prompted to sign in to view the embedded Excel spreadsheet, even though link sharing was previously set to 'anyone with the link'.
Ensure you have access to your Microsoft 365 Admin Center, as resolving authentication prompts for public embeds often requires organization-level administrative privileges.
Verify File Permissions and Embed Link Type
Ensure the individual file is properly configured for anonymous public access before generating the embed code.
Even if you generated an embed code, the underlying file permission must allow anonymous viewing. If the link was set to internal users only, the iframe will ask website visitors to log in.
Navigate to the location of the Excel file you wish to embed.
Click the 'Share' icon next to the file, click the gear icon to open link settings, and select 'Anyone with the link'.
Open the file in Excel for the Web, go to File > Share > Embed, and copy the provided iframe code.
Replace the old embed code on your website with the newly generated one.
Adjust Organization-Wide Sharing Policies
Fix tenant-level restrictions that override individual file settings and force sign-ins for external viewers.
Avoid Complex Cloud Policies with WPS Office
If Microsoft 365's strict tenant policies prevent you from sharing spreadsheets easily, try WPS Office. It provides a lightweight, highly compatible alternative with straightforward file sharing and no mandatory authentication hurdles for simple public documents.
- 1. Download and Install: Get WPS Office for free and install it on your device.
- 2. Open Your Spreadsheet: Easily open and edit your existing Excel (.xlsx) files directly.
- 3. Share with Ease: Utilize WPS Cloud to generate simple public sharing links without strict organizational barriers.
Frequently Asked Questions
Why does my embedded Excel sheet still ask for a password even with an 'Anyone' link?
This usually happens because your organization's SharePoint or OneDrive sharing policies have disabled anonymous access at the tenant level, which overrides your file-level 'anyone with the link' setting.
Can I embed an Excel file on my website for public editing?
While possible by setting the link permissions to 'Anyone can edit', it is highly discouraged for public websites due to significant security risks and the potential for malicious data alterations.
How do I know if my organization blocks public file sharing?
When trying to create a sharing link in OneDrive or SharePoint, the 'Anyone with the link' option will be grayed out or entirely unavailable, indicating that tenant policies restrict anonymous access.
Are there other tools to embed a spreadsheet publicly?
Yes, you can use built-in 'Publish to Web' features if available, or switch to alternative office suites and cloud drives that offer simpler public link-sharing options without enterprise-level restrictions.
