Forms connection to workbook lost- Please Help!!

Hi @Jenn Lo

Unfortunately, Microsoft Forms does not provide a way to reattach a form to a previously connected response workbook. Once the form has been disconnected and synced to a new workbook, Forms treats the new workbook as the active response workbook.

Since you still have your original customized workbook, I understand why you want to keep using it, especially because it is already formatted, shared, and connected to Zapier and your CRM. However, there is no supported Reconnect option in Forms that allows you to select that existing workbook as the response destination.

Here are 2 option you may consider:

1.Keep the new Forms-connected workbook and update your integrations

This is the simplest approach:

• Open the form.
• Go to Responses.
• Open the newly connected workbook.
• Update your Zapier connection to use the new workbook.
• Reconfigure any CRM integrations, sharing permissions, formulas, or reports that depend on the old workbook.

2.Use Power Automate to write responses to your original workbook

If preserving your original workbook is important because of its formatting, formulas, CRM integration, and reporting setup, this may be the better workaround.

You can create a Power Automate flow. This allows the form responses to continue arriving automatically while keeping your original workbook as the destination for the data. Please refer to How to Sync Microsoft Forms to Excel

This link is shared by community members for your convenience. It points to a third-party site that is not managed or verified by Microsoft. I can’t guarantee the quality, safety, or suitability of any content or software found there. Please review carefully and make sure you understand any potential risks before using it. 

If you need help setting up this Power Automate approach, I recommend posting in the Microsoft Power Platform Community, where you can get more targeted assistance with configuring the Forms - Excel flow and preserving your existing workbook structure.

I hope this gives you a clear path forward.

If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.