File Sharing Problems

Why Shared Microsoft Forms Excel Spreadsheets Require Sign-In

Rana Garcia Sep 29, 2026 869 views

Question details

External users are being prompted to sign into a Microsoft account when attempting to view a shared Microsoft Forms response spreadsheet.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing live Microsoft Forms response data with a user outside the organization's Microsoft 365 tenant.
Observed behavior: The recipient hits a sign-in wall and cannot access the workbook, even if a view-only sharing link was provided by the sender.

Before you start

Before troubleshooting, verify if your organization's IT policy allows sharing Microsoft 365 files with external users anonymously, as tenant-level security restrictions will override individual file sharing settings.

Solution 1Recommended

Export and Share a Static Excel or CSV File

The easiest way to bypass tenant sign-in restrictions is to download the responses locally and share the static file directly.

When a workbook is tied to Microsoft Forms and hosted on SharePoint or OneDrive, it inherits strict organizational sharing rules. Exporting the file detaches it from the tenant, allowing you to share it freely via email or third-party cloud storage.

Open Microsoft Forms

Log into your Microsoft 365 account and open the specific form you want to share data from.

Navigate to Responses

Click on the 'Responses' tab at the top of the form editing page.

Download the Spreadsheet

Click the 'Open in Excel' button. This will download a static .xlsx copy of the current responses to your local computer.

Share the Local File

Attach the downloaded Excel file to an email or send it via your preferred file-sharing method to the external user.

Export and Share a Static Excel or CSV File

Static Data Limitation: Because this is a downloaded copy, it will not automatically update when new form responses are submitted.

Solution 2

Adjust Link Settings for Anonymous Access

Generate an 'Anyone with the link' sharing URL if your organization's policies permit anonymous access.

Solution 3

Invite the User as an External Guest

Add the external user to your organization's Microsoft Entra ID (Azure AD) directory to grant them authenticated access.

Free Microsoft Office alternative

Handle and Share Spreadsheets Easily with WPS Office

If you frequently deal with exported Microsoft Forms data and want a hassle-free way to view, edit, and share Excel files without worrying about complex tenant permissions, WPS Office provides a lightweight, highly compatible, and free alternative to Microsoft Office.

1. Download WPS Office: Install WPS Office for free from the official website on your PC or Mac.
2. Open Exported Data: Open the exported Microsoft Forms Excel (.xlsx) file directly in WPS Spreadsheets.
3. Edit and Share: Freely format the data and share the file with anyone, bypassing tenant-level sign-in restrictions.

Fully compatible with Microsoft Excel (.xlsx) and CSV formats.Share local spreadsheets effortlessly via email or alternative cloud services.No complex tenant permissions or sign-in walls for local files.Familiar user interface makes it easy to switch without a learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Can I turn off the sign-in requirement for Microsoft Forms responses?

You can only turn off the sign-in requirement if your Microsoft 365 administrator allows 'Anyone with the link' (anonymous) sharing. If this is disabled at the tenant level, you cannot bypass it for live workbooks.

Why does a 'View Only' link still ask for a login?

'View Only' restricts the user from making edits; it doesn't automatically grant anonymous access. If the link was generated for 'People in my organization' or 'Specific people', the system will still require authentication to verify the viewer's identity.

Does the external user need a Microsoft account to be a guest?

Yes, if they are invited via Microsoft Entra ID to access restricted tenant files, they will either need to link their email address to a Microsoft account or use a one-time email passcode to verify their identity.

How do I share live Forms data without any sign-in prompts?

You must generate a sharing link from OneDrive or SharePoint set specifically to 'Anyone with the link can view'. If this option is grayed out, your IT administrator has blocked anonymous external sharing.

Document & File Issues