'%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 Get Authentication Keys for OneDrive for Business Excel Embeds
Question details
The user wants to know if they can obtain an authentication key to embed an Excel worksheet from OneDrive for Business on a website, similar to the functionality available in OneDrive Personal.
- Product
- Microsoft Excel / OneDrive for Business
- Device & OS
- not provided
- Scenario
- Embedding an Excel worksheet on a public or internal website for visitors to view.
- Observed behavior
- OneDrive for Business embed codes do not include a user-accessible authentication key, often resulting in visitors being prompted to sign in to Microsoft 365.
Before attempting to embed files for public viewing, verify with your organization's IT department that external sharing and anonymous access are permitted on your Microsoft 365 enterprise account.
Configure 'Anyone with the link' Sharing Permissions
Use organizational sharing settings to allow public access to your embedded Excel file instead of relying on an authentication key.
OneDrive for Business relies on Microsoft 365 enterprise security policies rather than standard authentication keys. To allow public visitors to view your embedded Excel file without signing in, you must create a public sharing link and apply it to your website's embed code.
Navigate to your OneDrive for Business account in a web browser and open the Excel file you wish to embed.
Click the 'Share' button in the top right corner. In the link settings, select 'Anyone with the link' to allow anonymous access, then click 'Apply'. Copy this link.
Go to 'File' > 'Share' > 'Embed'. Adjust your display options (such as hiding gridlines or row/column headers) and copy the provided iframe code.
To ensure public access, paste the iframe code into your website's HTML, and replace the URL inside the `src` attribute with the public sharing link you generated in step 2.
Contact Your Microsoft 365 Admin for Access Configuration
If standard public sharing is restricted on your account, your organization's IT administrator must enable external sharing at the tenant level.
Try WPS Office for Seamless Spreadsheet Management
If strict sharing and embedding limits in OneDrive for Business are slowing down your workflow, WPS Office offers a free, lightweight, and highly compatible alternative for creating, editing, and sharing your spreadsheets without the enterprise hassle.
- 1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Microsoft Excel files seamlessly.
- 3. Edit and Share: Use comprehensive editing tools to modify your data and share them easily via direct file transfers or flexible cloud links.
Frequently Asked Questions
Can I generate an authentication key for OneDrive for Business embeds?
No, unlike OneDrive Personal, OneDrive for Business does not provide a standard, user-accessible authentication key in its embed codes. It strictly relies on organizational sharing permissions and Azure AD authentication.
Why do visitors have to sign in to see my embedded Excel file?
If the sharing link used in the embed code is restricted to 'People in your organization' or specific users, Microsoft 365 will prompt website visitors to log in to verify their identity and access permissions before displaying the file.
How can I embed a OneDrive for Business Excel file without requiring users to log in?
To allow public access, you need to generate an 'Anyone with the link' sharing URL and apply it to your embed iframe. If this option is unavailable, your Microsoft 365 administrator must enable external anonymous sharing for your organization.
