CODEWITHSUNDEEP
excelsharepointms-forms
PhantomICEMAN
PhantomICEMAN

Reputation: 9

Disconnect Excel Workbook from an MS Form

Due to recent changes by Microsoft regarding how MS Forms data synchronizes with Excel, we've implemented our own sync solution through Power Automate to ensure it's done automatically. However, this has led to an issue where opening the Excel file to check data or make amendments triggers MS Forms to attempt a resync, causing data duplication.

I'm looking for a safe way to disconnect the workbook from Excel so that only Power Automate manages the sync process. I've searched for solutions ,I have checked in Excel but haven't found any connections in Excel that allow for this. One option I considered is disconnecting and syncing to a new workbook, but I'm hoping there's a cleaner method. Any suggestions?

Upvotes: 0

Views: 35

Answers (0)

Related Questions