Permission & Access Issues

How to Fix Forms and Excel Sync Permission Errors in SharePoint

Kushani Nimanthika Oct 7, 2026 868 views

Question details

Users are experiencing synchronization errors between Microsoft Forms and Excel in SharePoint, typically requiring co-authoring permissions.

How to Fix Forms and Excel Sync Permission Errors in SharePoint

Product: Microsoft Excel, Microsoft Forms, SharePoint
Device & OS: not provided
Scenario: Syncing response data from Microsoft Forms to an Excel workbook hosted on a SharePoint site.
Observed behavior: A synchronization error occurs indicating a lack of co-authoring permissions or insufficient access to the SharePoint folder or response workbook.

Before you start

Ensure you are logged into SharePoint with the correct Microsoft 365 administrator account or site owner account so you have the authority to view and modify document library permissions.

Solution 1Recommended

Verify and Grant Document Library Permissions

Check if the affected user has the required Edit or Full Control permissions for the SharePoint document library containing the response workbook.

This error most commonly occurs when a user does not have adequate access rights to the folder where the original response workbook is stored. Standard view access is not enough for the sync to function properly.

Navigate to Library Settings

In SharePoint, open the site, go to the specific document library housing the Excel file, and click on the 'Library Settings' gear icon.

Open Permissions

Select 'Permissions for this document library' from the settings menu to view the access control list.

Check User Permissions

Click on 'Check Permissions' in the top ribbon, enter the user's email address in the search box, and select 'Check Now' to view their current access level.

Grant Access

If the permissions are listed as Read or View only, ask the site owner to grant 'Edit' or 'Full Control' permissions to the user to restore synchronization.

Permission Inheritance: Granting Edit permissions at the Document Library level will automatically grant edit access to all files within it, provided they inherit permissions.

Solution 2

Remove Unique Permissions on the Workbook

Ensure the response workbook inherits permissions from the library and doesn't have restrictive unique permissions applied directly to the file.

Solution 3

Escalate to Microsoft 365 Support with HAR Logs

If all permissions are correctly set to Edit or Full Control but the sync error persists, escalate the issue to support with diagnostic logs.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

While Microsoft Forms and SharePoint sync issues require specific Microsoft 365 ecosystem permissions to fix, you can rely on WPS Office as a lightweight, highly compatible alternative for everyday spreadsheet and form data tasks.

Fully compatible with Microsoft Excel (.xlsx) file formats.Lightweight and fast, avoiding heavy cloud ecosystem sync errors.Built-in smart form features and powerful data analysis tools.Free to use with a familiar, easy-to-navigate tabbed interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Forms say I lack co-authoring permissions?

This error appears when the Excel workbook used to collect Forms responses is stored in a SharePoint library where your account does not have 'Edit' or 'Full Control' permissions. Without edit access, the system cannot write new form entries into the Excel file.

Can I sync Microsoft Forms to a local Excel file instead of SharePoint?

By default, forms created in SharePoint, Teams, or OneDrive automatically sync to an online workbook. You can download a static copy of the responses as a local Excel file at any time, but real-time data syncing requires the cloud-hosted workbook.

What does it mean if my workbook has unique permissions?

Unique permissions mean that specific access rules have been applied directly to the Excel file, overriding the general permissions of the SharePoint folder it lives in. This can unintentionally block access for users who normally have permission to edit files in that folder.

How do I know if my SharePoint permissions were updated successfully?

You can verify your updated permissions by having the site administrator navigate to Library Settings > Permissions for this document library, and running the 'Check Permissions' tool with your email address. It should return 'Edit' or 'Full Control'.

Document & File Issues