File Sharing Problems

Fix Sign-In Requests for an Embedded OneDrive Excel Range

Algirdas JasaitisAlgirdas Jasaitis Nov 18, 2026 868 views

Question details

The user wants people to edit an embedded Excel range without being prompted to sign in.

Fix Sign-In Requests for an Embedded OneDrive Excel Range
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.
Before you start

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.

Solution 1Recommended

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.

1
Open sharing settings

In OneDrive, select the workbook and choose Share, then open the link settings.

2
Allow link editing

Select Anyone with the link if available, enable Allow editing, and apply the settings. Copy the resulting link.

3
Test the sharing 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.

4
Test the embedded range

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.

Check the OneDrive sharing link and test the embedded range
Anyone links grant broad access: Anyone who receives an editing link may be able to change the workbook. If the Anyone option is unavailable, check your account or organization sharing policies.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesUse familiar spreadsheet tools to work with ranges and formulasMove existing Office files into a familiar, easy-to-use workspaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

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.