Data Import & Export

Can You Link Microsoft Forms Responses Back to an Old Excel Workbook?

Maira Mehtab Sep 20, 2026 869 views

Question details

The user wants to know if it is possible to reconnect Microsoft Forms responses back to an original Excel workbook after the connection was broken and a new synchronized workbook was created.

Product: Microsoft Forms / Microsoft Excel
Device & OS: not provided
Scenario: Attempting to redirect the synchronization of new Microsoft Forms responses back to an older, previously disconnected Excel file.
Observed behavior: Microsoft Forms automatically creates a new synchronized Excel workbook and does not provide an option to redirect or link the ongoing sync back to the original workbook.

Before you start

Before proceeding, ensure you have access to both the newly generated Excel workbook that is currently syncing with your form and the older workbook containing your historical data.

Solution 1Recommended

Merge Old Response Data into the New Synchronized Workbook

Since Microsoft Forms cannot reconnect to an old workbook by design, the standard solution is to manually copy your historical data into the newly synchronized workbook.

Microsoft Forms establishes a strict one-way connection to an Excel workbook. Once a workbook is disconnected and responses are synced to a new file, the connection cannot be reverted. Merging the data manually ensures all your responses remain in one master document.

Open Both Workbooks

Launch Microsoft Excel and open the old workbook containing your previous responses, as well as the newly synchronized workbook.

Select the Historical Data

In the old workbook, click and drag to highlight all the previous response rows. Do not include the header row if your new workbook already has one.

Copy the Data

Press Ctrl+C (or right-click and select Copy) to copy the highlighted historical responses to your clipboard.

Paste into the New Workbook

Navigate to the new synchronized workbook, right-click the first empty row beneath the newly synced responses, and select Paste (or press Ctrl+V) to combine the data.

Feature Request: If you would like the ability to select specific destination workbooks in the future, you can submit feedback directly to Microsoft requesting this capability.

Free Microsoft Office alternative

Handle Your Spreadsheet Data Easily with WPS Office

While Microsoft Forms restricts workbook reconnection, you can seamlessly manage, merge, and analyze all your exported form data using WPS Office. It provides a lightweight, highly compatible spreadsheet environment without the heavy subscription costs.

1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your computer.
2. Open Your Exported Data: Launch WPS Spreadsheet and open both your old and new Microsoft Forms Excel export files (.xlsx).
3. Merge Seamlessly: Use familiar copy, paste, and data management tools within WPS to consolidate your form responses into a single, unified spreadsheet.

Fully compatible with Microsoft Excel formats (.xlsx, .xls).Lightweight software that opens large data files quickly and efficiently.Familiar user interface with zero learning curve for Excel users.Free alternative to Microsoft Office with a robust suite of productivity tools.

Frequently Asked Questions

Can I change the destination Excel file for my Microsoft Forms responses?

Once a form is synced to a new Excel workbook in SharePoint or OneDrive, you cannot manually change the destination back to a previous or different existing workbook. You can only disconnect and create a brand new sync file.

Will disconnecting my form delete the existing responses?

No, disconnecting the form from Excel will not delete the data in the existing Excel workbook, nor will it delete the responses stored securely within Microsoft Forms itself.

How do I export my Microsoft Forms data without live syncing?

You can download a static copy of your responses by navigating to the 'Responses' tab in your Microsoft Form and clicking 'Open in Excel'. This creates a one-time downloaded file rather than an active, live-synced workbook.

Excel & Data Problems