Others

How to Preserve Microsoft Forms Ownership When the Creator Leaves

John Wilson Oct 9, 2026 869 views

Question details

Ensure Microsoft Forms and linked Excel data remain accessible and synchronized after the original creator's account is deleted.

How to Preserve Microsoft Forms Ownership When the Creator Leaves

Product: Microsoft Forms
Device & OS: not provided
Scenario: An employee is leaving the organization, and their active forms are needed for continuous data collection without losing historical responses.
Observed behavior: When the creator's user account is permanently deleted, the form, its historical responses, and the linked Excel data workbook become inaccessible or are lost.

Before you start

Ensure you perform these actions before the departing user's account is permanently deleted from the directory, as Microsoft 365 typically only retains user data for a 30-day grace period.

Solution 1Recommended

Move the Form to a Microsoft 365 Group

Moving the form to a shared group is the most effective way to ensure continuous access, preserve historical data, and maintain the original form URL.

By transferring ownership from an individual's OneDrive to a Microsoft 365 Group, the form becomes tied to the organization rather than a single user account.

Access the original form

Log into Microsoft Forms with administrator privileges, or have the original owner log in before their departure.

Locate the form options

Navigate to 'My forms', find the specific form you wish to transfer, and click the 'More options' (three dots) icon in the top-right corner of the form card.

Select move destination

Click 'Move to a group' from the dropdown menu and select the appropriate Microsoft 365 Group or SharePoint site to take over ownership.

Form URL Unchanged: Moving the form to a Microsoft 365 group preserves the original URL, meaning respondents can continue to submit data without interruption.

Solution 2

Export Responses and Recreate via Excel for the Web

If the form cannot be moved directly, you can export the history and create a replacement form bound to a shared workbook.

Solution 3

Set Up Power Automate for Ongoing Synchronization

Use Power Automate to capture new responses and route them to an independent Excel file stored safely in a SharePoint site.

Free Microsoft Office alternative

Analyze Your Exported Form Data Seamlessly with WPS Office

If you need to analyze, format, and organize exported Microsoft Forms data without relying on an expensive Microsoft 365 subscription, WPS Office provides a powerful, lightweight, and completely free spreadsheet alternative.

1. Download and Install: Visit the official WPS Office website and download the free desktop application.
2. Open Your Data: Launch WPS Spreadsheets and open the .xlsx file you exported from Microsoft Forms.
3. Analyze Responses: Use built-in data sorting, filtering, and pivot tables to summarize your collected responses.

100% compatibility with Microsoft Excel (.xlsx) and CSV formats.Advanced data analysis and pivot table tools to efficiently review form responses.Lightweight software with a familiar user interface for seamless migration.Built-in PDF tools for converting your form data reports and sharing them securely.

microsoft office alternative - wps office

Frequently Asked Questions

Does duplicating a form keep it synchronized with the original Excel workbook?

No. When you duplicate a form through the online interface, it generates a completely new link and does not automatically synchronize its responses with the original Excel workbook.

What happens if the creator's account is deleted before transferring form ownership?

Microsoft 365 typically retains user data for a limited grace period (usually 30 days) after account deletion. If the form ownership is not transferred before this period expires, the form and its response data will be permanently deleted.

Should I move the form's Excel workbook to another employee's personal OneDrive?

It is highly recommended to move the workbook and store long-term organizational data in a SharePoint site or Microsoft 365 Group instead of another individual's OneDrive. This prevents the same ownership and access issues if that new employee eventually leaves.

Can I keep form responses synchronized by recreating it in OneDrive?

While you can create a form in OneDrive via Excel for the Web to enable synchronization, moving it to a Microsoft 365 group is a more reliable way to maintain continuous group access and sync without breaking the form's URL.

Office Quick Solutions