Others

How to Keep Microsoft Forms Responses in the Original Excel Workbook

Steven Parker Oct 13, 2026 870 views

Question details

The user wants to prevent Microsoft Forms from creating a new Excel workbook for responses whenever the form is updated.

How to Keep Microsoft Forms Responses in the Original Excel Workbook

Product: Microsoft Forms and Excel
Device & OS: not provided
Scenario: Modifying an existing Microsoft Form and managing where the submitted response data is stored.
Observed behavior: Updating the form generates a completely new response workbook instead of continuing to append new data to the original Excel file or SharePoint list.

Before you start

Verify whether your form was originally created directly in the Microsoft Forms portal, or if it was created through SharePoint Online or OneDrive for Business, as this dictates how the Excel sync behaves.

Solution 1Recommended

Verify Form Creation Source and Cloud Connection

Forms created in SharePoint Online or OneDrive for Business maintain a live link to the original workbook, whereas standard forms generate static or disconnected files.

If your form was created directly in the Microsoft Forms web app, downloading responses creates a static offline Excel file. Every time you download it again, a new file is created. To keep a continuous live link where updates don't break the connection, the form must be initiated from OneDrive for Business or SharePoint Online.

Check the Responses Tab

Open your form in Microsoft Forms and navigate to the 'Responses' tab. Look at the Excel icon button used for opening responses.

Look for the Cloud Icon

If the Excel button has a small cloud icon on it, your form has a live connection to an original workbook hosted on OneDrive or SharePoint. New responses and form updates should sync here automatically.

Re-establish Sync if Broken

If the cloud icon is missing or the original file was moved/renamed, the link is broken. You must click the Excel icon to 'Sync all responses to a new workbook' to re-establish a live cloud connection going forward.

Verify Form Creation Source and Cloud Connection

Creating Live-Linked Forms: For future forms, start by opening OneDrive for Business or your SharePoint document library, click 'New', and select 'Forms for Excel'. This guarantees the responses will always route to that specific original workbook.

Free Microsoft Office alternative

Analyze Form Responses Seamlessly with WPS Office

If you are downloading disconnected Microsoft Forms response files and need an efficient way to merge, edit, or analyze the data, WPS Office is an excellent free Microsoft Office alternative. It offers powerful spreadsheet tools to handle your exported data without complex cloud requirements.

1. Download WPS Office: Install the free WPS Office suite on your device.
2. Open Response Data: Launch WPS Spreadsheet and open the .xlsx response file downloaded from Microsoft Forms.
3. Analyze Data: Use WPS Spreadsheet's PivotTables and charting features to organize and interpret your form responses.

Fully compatible with Microsoft Excel (.xlsx, .xls) files generated by Microsoft Forms.Free and lightweight, allowing you to load large survey response datasets quickly.Familiar user interface makes data analysis intuitive with zero learning curve.Built-in advanced formulas and pivot tables for comprehensive survey analysis.

microsoft office alternative - wps office

Frequently Asked Questions

Why did Microsoft Forms create a new Excel workbook instead of using the old one?

This happens if the original Excel file was moved, renamed, or deleted from its SharePoint or OneDrive location. It can also occur if the form was not originally created as a 'Forms for Excel' file, meaning the system has to generate a new static file each time you request a download.

Can I manually link an existing Microsoft Form to an older Excel workbook?

No. Once a live connection between Microsoft Forms and an Excel workbook is broken, you cannot manually map it back to the exact old file. You must allow Forms to sync to a new workbook, and then manually copy over any historical data if needed.

How do I know where my Microsoft Forms response workbook is stored?

If you have a live cloud link (indicated by a cloud icon on the Excel button in the Responses tab), hovering over or clicking the Excel button will open the file in Excel for the Web. You can then click the file name at the top left of the screen to see its exact OneDrive or SharePoint directory path.

Office Quick Solutions