Permission & Access Issues

Fix Excel Forms Error: Workbook Belongs to Someone Else

Rana Garcia Sep 27, 2026 870 views

Question details

The user is unable to create a form from an Excel workbook stored in SharePoint or OneDrive due to an ownership error message.

How to Fix Excel Forms Error: Workbook Belongs to Someone Else

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to create a Microsoft Form directly from an existing Excel workbook located in a SharePoint document library or personal OneDrive.
Observed behavior: An error message appears stating that only the OneDrive owner can create a form, which persists even if the workbook is copied or moved to a personal OneDrive.

Before you start

Verify that you are actively logged into the correct Microsoft 365 account and ensure your network connection to SharePoint or OneDrive is stable.

Solution 1Recommended

Create a New Workbook and Migrate Existing Data

This is the most effective workaround when background permission glitches lock the form creation feature on an existing Excel file.

Sometimes, legacy permissions or synchronization errors get tied to a specific file's metadata. By creating a brand-new file directly in the desired SharePoint location, you generate a clean metadata slate that typically restores full Microsoft Forms integration.

Create a new file

Navigate to the exact SharePoint document library or OneDrive folder where you want the file to reside, click 'New', and select 'Excel workbook'.

Test form creation

Open the newly created workbook, go to the 'Insert' tab on the ribbon, and click 'Forms' followed by 'New Form'.

Transfer original data

If the form creation interface opens successfully without the ownership error, open your original problematic workbook.

Paste into the working file

Copy all the required data from the old workbook and paste it into the new one, then safely delete or archive the old file.

Create a New Workbook and Migrate Existing Data

Data Preserved: Migrating data to a fresh workbook retains all your spreadsheet information while permanently bypassing the background file-ownership conflict.

Solution 2

Verify SharePoint Access and User Permissions

Check if your account has the correct permission level to execute form integrations within the shared directory.

Free Microsoft Office alternative

Experience Hassle-Free Spreadsheets with WPS Office

If you frequently encounter complex permission barriers, syncing issues, or account integration errors with Microsoft Excel, consider switching to WPS Office. It provides a lightweight, incredibly stable environment for all your document and spreadsheet needs without restrictive cloud-lock features.

1. Download and Install: Visit the official WPS Office website to download the free installation package for your operating system.
2. Open Your Workbooks: Launch WPS Spreadsheets and open your existing .xlsx files directly; no complex format conversions are required.
3. Edit and Save Seamlessly: Enjoy a robust set of data analysis, formatting, and charting tools, saving your work locally or to your preferred cloud drive without permission conflicts.

Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formatsLightweight application ensuring fast startup and smooth editingFree to use with a highly familiar, easy-to-navigate ribbon interfaceSeamless local and cloud storage management without complex ownership errors

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel Forms say the workbook belongs to someone else?

This error is typically caused by a mismatch in SharePoint or OneDrive metadata. It happens if the file was originally created by another user, if it was moved from a different directory while retaining old permissions, or if there is a synchronization delay in Microsoft 365 servers verifying your ownership.

Can I transfer ownership of an Excel workbook in SharePoint to fix this?

Yes. Site Administrators can update file ownership by navigating to the SharePoint document library, selecting the file, clicking 'Manage Access', and explicitly granting Owner rights to your account. However, migrating the data to a new file is often much faster.

Does this error occur in desktop Excel or just Excel for the Web?

This specific Microsoft Forms integration error primarily occurs in Excel for the Web (SharePoint and OneDrive online environments) because the Insert > Forms feature relies heavily on cloud-based Microsoft 365 group permissions.

Document & File Issues