Fix Sign-In Requests for an Embedded OneDrive Excel Range
Question details
The user wants people to edit an embedded Excel range without being prompted to sign in.

- Product
- OneDrive and Excel for the web
- Device & OS
- not provided
- Scenario
- A selected range from a workbook is embedded for editing, with sharing set to allow anyone with the link to edit.
- Observed behavior
- Users are prompted to sign in when they access the embedded range.
Open the workbook in OneDrive and confirm that you can change its sharing settings. Keep the page containing the embedded range available so you can test it separately from the sharing link.
Check the OneDrive sharing link and test the embedded range
Verify that the workbook link permits editing, then determine whether the sign-in prompt is specific to the embed.
An anyone-with-the-link setting does not guarantee anonymous editing in an embedded workbook or selected range. Availability can also depend on the account and organization settings.
In OneDrive, select the workbook and choose Share, then open the link settings.
Select Anyone with the link if available, enable Allow editing, and apply the settings. Copy the resulting link.
Open a private or incognito browser window, paste the copied link, and check whether you can access and edit the workbook without signing in.
In the same private browser window, open the page containing the embedded range and check whether editing prompts you to sign in. Compare the result with the direct-link test.

Use a sharing link or form instead of embedded editing
Use a separate access or data-entry method if the embedded range requires authentication.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing spreadsheets. Its Microsoft Office format compatibility helps you move existing files into WPS; it does not change OneDrive's embedded sign-in requirements.

Frequently Asked Questions
Why does the embedded Excel range ask users to sign in?
OneDrive or Excel for the web may require authentication for an embedded workbook or range, particularly when editing is enabled. An anyone-with-the-link setting does not necessarily override that requirement.
How can I check whether the direct link allows anonymous editing?
In OneDrive, choose Share for the workbook, select Anyone with the link and Allow editing if available, and copy the link. Open it in a private browser window and try editing without signing in.
What if the Anyone with the link option is unavailable?
The option may be restricted by your account or organization. Check with the administrator responsible for OneDrive sharing policies.
Can I collect data without letting users edit the embedded workbook?
Yes. Create a form in a form service and share its response link. Check the form's sharing settings and test whether respondents can submit without signing in.




