Permission & Access Issues

How to Protect Microsoft Forms Responses from Manual Changes in Excel

Maira Mehtab Sep 21, 2026 869 views

Question details

The user wants to know how to prevent unauthorized manual edits to Microsoft Forms responses that are synchronized to an Excel workbook, and how to recover original data if the workbook is changed.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Managing permissions and data integrity for survey or quiz responses exported to an Excel workbook via OneDrive or SharePoint.
Observed behavior: Form responses are stored in the form and synced to an Excel workbook. Users with edit access to the folder can manually alter the workbook, though these changes do not sync back to the original form data.

Before you start

Ensure you have administrative or owner access to both the Microsoft Form and the OneDrive or SharePoint location where the synced Excel workbook is stored.

Solution 1Recommended

Restrict Workbook Editing Access in OneDrive or SharePoint

Prevent manual changes to the exported data by adjusting the sharing permissions of the Excel workbook in its storage location.

Since the Excel workbook containing your form responses is stored in OneDrive for Business or SharePoint Online, its security relies on the file permissions of that platform. By default, anyone with edit access to the folder can modify the workbook.

Locate the file

Navigate to the OneDrive for Business or SharePoint document library where the Excel workbook is stored.

Manage access

Right-click the Excel workbook and select 'Manage access' or click the 'Share' icon.

Adjust permissions

Review the list of users and groups. Change the permission level from 'Can edit' to 'Can view' for users who only need to read the data, or remove unauthorized users entirely.

Solution 2

Sync All Responses to a New Workbook

Use this solution if your existing Excel workbook has already been corrupted or manually altered, allowing you to generate a fresh copy of the original responses.

Free Microsoft Office alternative

Secure Your Exported Data with WPS Office

WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office. With a familiar UI, you can seamlessly migrate your workflow and easily manage your exported .xlsx form responses, applying robust spreadsheet protection without the heavy subscription costs.

1. Open your response data: Download your form responses as an .xlsx file and open it using WPS Spreadsheet.
2. Access protection tools: Navigate to the 'Review' tab on the top ribbon and select 'Protect Sheet'.
3. Set edit restrictions: Enter a secure password and configure the permissions to block unauthorized users from making manual changes to your data.

Fully compatible with Microsoft Excel (.xlsx) formats for seamless data transfer.Easily apply passwords and lock specific cells to protect survey data from manual changes.Familiar user interface makes migrating from Microsoft Office completely effortless.Lightweight application size ensures fast loading times for large response datasets.Free to use across Windows, Mac, Linux, iOS, and Android devices.

microsoft office alternative - wps office

Frequently Asked Questions

Do manual changes in the Excel workbook affect the original Microsoft Forms data?

No. The synchronization is one-way from Microsoft Forms to the Excel workbook. Any additions, deletions, or edits made directly in the Excel file will not sync back to alter the original responses in Microsoft Forms.

Can I lock specific columns in the synced Excel workbook?

Yes. You can use standard Excel protection features to lock specific cells or columns while allowing the workbook to remain synced. However, ensure that you do not lock the active rows where new form responses are continuously being appended, as this might disrupt the synchronization process.

Why isn't my new Excel workbook automatically updating with new responses?

If you manually downloaded a static copy of the responses or created an independent Excel file, it will not update. To restore live synchronization, you must click the three-dot menu next to 'Open results in Excel' inside the Forms 'Responses' tab and choose 'Sync all responses to a new workbook'.

Document & File Issues