File Sharing Problems

How to Copy Microsoft Forms and Keep the Live-Linked Excel Workbook

Camila Milosovich Oct 23, 2026 868 views

Question details

The user wants to duplicate a Microsoft Form while maintaining or recreating the live-linked Excel workbook that automatically records form responses.

How to Copy a Microsoft Form with a Live-Linked Excel Workbook

Product: Microsoft Forms and Excel
Device & OS: not provided
Scenario: Sharing or duplicating a form template for colleagues while ensuring response data is automatically collected in a linked spreadsheet.
Observed behavior: When a Microsoft Form is copied, the original live-linked Excel workbook is not transferred, leaving the new form without an active destination for live response tracking.

Before you start

Ensure you have an active Microsoft 365 account with access to OneDrive, SharePoint, or Excel for the web, as live-linked workbooks require these specific platforms to function properly.

Solution 1Recommended

Duplicate the Form and Recreate the Live-Linked Workbook

Use the built-in copy function and manually generate a new live-linked workbook via the Responses tab to restore the automatic data connection.

Duplicating a form intentionally breaks the link to the original workbook to prevent data overlap. You must generate a new connection after copying the form.

Copy the original form

Navigate to the Microsoft Forms portal, click the three-dot menu next to the form title you wish to duplicate, and select 'Copy'.

Access the responses tab

Open the newly duplicated form. At the top of the form editing interface, click on the 'Responses' tab.

Create a new live link

Click the 'Open in Excel' button. Because this is a new form, this action automatically creates a brand new live-linked Excel workbook to store future responses.

Locate and save the workbook

The new live-linked workbook will be generated and saved in your OneDrive or SharePoint account. Ensure colleagues have the necessary sharing permissions to view this new file.

Important Requirement: Live-linked workbooks are only supported when the initial form is created within OneDrive, SharePoint, or Excel for the web. Standard forms created directly on the Forms portal will download a static offline spreadsheet instead.

Free Microsoft Office alternative

Easily Manage Spreadsheets and Data with WPS Office

While Microsoft Forms requires specific OneDrive setups for live-linking, WPS Office provides a lightweight, highly compatible alternative for analyzing exported form data and managing spreadsheets across devices.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open Exported Data: Launch WPS Spreadsheet and open the downloaded .xlsx file containing your static form responses.
3. Analyze Data Effortlessly: Utilize built-in charts, pivot tables, and advanced formulas to process and visualize your response data securely.

Fully compatible with Microsoft Excel (.xlsx) formatsLightweight design ensures fast loading and smooth data processingFree and easy-to-use interface identical to classic spreadsheet softwareBuilt-in PDF conversion and powerful collaborative data analysis tools

Frequently Asked Questions

Why isn't my copied Microsoft Form updating the original Excel workbook?

When you duplicate a Microsoft Form, it creates a completely independent copy. It intentionally disconnects from the original Excel workbook to prevent mixing new response data with the old data.

Where is the new live-linked Excel workbook saved after I click 'Open in Excel'?

If the form was created or copied within a Microsoft cloud environment, the newly generated workbook will be saved automatically in the corresponding OneDrive or SharePoint folder associated with your account.

Can I link a copied Microsoft Form to an already existing Excel workbook?

No, Microsoft Forms does not currently support linking a new or copied form to an already existing Excel workbook. Clicking 'Open in Excel' will always generate a fresh, blank workbook for that specific form.

Why is the 'Open in Excel' option downloading a static file instead of creating a live link?

This happens if the form was created on the standard Forms web portal instead of originating from OneDrive, SharePoint, or Excel for the web. Live-linking requires the form to be hosted directly within a Microsoft cloud storage environment.

Document & File Issues