Others

Fix Errors When Creating Forms for Excel from OneDrive

Kushani NimanthikaKushani Nimanthika Oct 29, 2026 868 views

Question details

A specific user is encountering errors when attempting to create a Form for Excel from OneDrive, while other users in the same tenant do not experience this issue.

How to Fix Errors When Creating Forms for Excel from OneDrive
Product
Microsoft Excel, OneDrive
Device & OS
not provided
Scenario
Creating a Form for Excel using OneDrive or SharePoint Online.
Observed behavior
The creation process fails with an error for one specific user, even though others in the tenant can successfully create forms.
Before you start

Ensure the affected user has an active Microsoft 365 license assigned and confirm they have the necessary permissions to create files in the target OneDrive or SharePoint document library.

Solution 1Recommended

Clear Browser Cache and Use InPrivate Mode

Resolve potential browser caching conflicts or stale session tokens causing the form creation to fail.

Often, single-user issues in web applications are caused by corrupted local cache data or outdated authentication tokens in the browser. Using an InPrivate or Incognito window forces a fresh session.

1
Sign out of Microsoft 365

Click on the user profile icon in the top right corner of OneDrive or Office.com and select 'Sign out' to completely end the current session.

2
Clear browser cache

Go to your web browser settings, locate the privacy or history section, and clear the browsing data (cache and cookies).

3
Open an InPrivate window

Launch a new InPrivate (Edge) or Incognito (Chrome) window and navigate to OneDrive.

4
Test form creation

Log back into the Microsoft 365 account and attempt to create the Form for Excel again.

Clear Browser Cache and Use InPrivate Mode
Browser Compatibility: If the issue is resolved in an InPrivate window, the problem was likely cache-related. It is also recommended to ensure the browser is updated to the latest version.
Free Microsoft Office alternative

Use WPS Office for Seamless Spreadsheet and Form Management

While Microsoft 365 backend issues can disrupt your workflow, WPS Office offers a lightweight, free alternative with robust spreadsheet capabilities. WPS Spreadsheet is fully compatible with Microsoft Excel formats, allowing you to manage data, create surveys, and collaborate without complex tenant permission errors.

  1. 1. Download WPS Office: Visit the official WPS Office website to download and install the free software.
  2. 2. Open WPS Spreadsheet: Launch WPS Spreadsheet to create or edit your data collection files and forms.
  3. 3. Save in Excel Format: Save your work seamlessly in standard .xlsx format to ensure full compatibility with other users.
Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Built-in smart forms and data collection tools that are easy to deploy.Lightweight software with fast performance and no complex tenant configurations.Free to download and use with a highly familiar user interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why can only one user not create a Form for Excel in OneDrive?

This usually happens due to a corrupted browser cache, a stale login session, or a specific backend permission glitch affecting only that user's Microsoft 365 account profile.

Are Forms for Excel and Microsoft Forms the same thing?

While they use the same underlying Microsoft Forms engine, 'Forms for Excel' automatically connects the form to an Excel workbook in OneDrive or SharePoint, allowing live data syncing as responses are submitted.

What should I do if Forms for Excel creation fails in both OneDrive and SharePoint?

If the failure occurs across all Microsoft 365 cloud storage locations for a specific user, an administrator should open a support ticket with Microsoft to investigate the user's backend service logs and tenant configuration.

Can I recover data if a Form for Excel stops syncing to my workbook?

Yes, you can manually sync the latest responses by opening the form in Microsoft Forms, going to the Responses tab, and clicking 'Sync all responses to a new workbook'.