Forms not syncing with online workbook

Question

Hello,

When I try and sync/load form responses automatically into an online excel sheet through the forms app or OneDrive, I get the following message

Open from Forms This form is linked to a different workbook. Go to Forms to open the linked workbook. (preview)

when I first open the spreadsheet it says the following, so I know it should Sync, and the work book is connected to that workbook as it was generated from that MS Form.

Syncing... This workbook syncs automatically with changes in Microsoft Forms. (preview)

opening a new work book each time i get new form responses wont work as i would have to redo multiple formulas in the sheet every time.

I know this feature (automatic syncing to online workbook) is reasonably new (Jan 24?) but I could really do with it working for a project I'm working on. Has anyone had this issue and found a solution? I've tried opening the work book directly from online one drive and through the forms app as well as trying it on different PC's all to no luck.

I'm sure it did work when I first tried forms about a week ago on a different form

Thanks

Answer 1

I have the same problem and have tried the same workarounds but they don't work