Share via

"Forms has a new and improved sync with Excel. To continue syncing new responses, you must update this workbook soon."

Anonymous
2024-12-02T15:19:05+00:00

When I try to do so, I am denied permission to my own spreadsheet that I can assure you I am the owner of. This is very disruptive. Please advise--I rely on this spreadsheet to do my job.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2024-12-03T07:41:08+00:00

Hi EmiHLC

Welcome to Microsoft Community.

I realize that you've encountered a problem with " Forma's sync issue with OneDrive " and I understand how you feel. Don't worry, I'll do my best to help you.

According to your description, is there any error message when you are denied access? If possible, please upload a picture of the error message, which will help me better locate the problem and solve it for you.

Here are some possible solutions:

First, make sure you are using the latest version of Excel and Microsoft Forms. The new synchronization solution requires you to open the workbook in Excel web version to synchronize new replies

Second, check whether you have the correct permissions to access and edit the workbook. Even if you are the owner of the workbook, sometimes there may be problems with the permission settings. Try the following steps:

  1. Find the workbook in OneDrive or SharePoint.
  2. Right-click the workbook and select "Share".
  3. Confirm that you have full control permissions in the sharing settings. If not, try to reassign permissions.

If none of these methods solve the problem, you can try to create a new Excel workbook and resynchronize all replies. The specific steps are as follows:

  1. Open Microsoft Forms in the browser.
  2. Go to the "View Responses" tab.
  3. Click the drop-down arrow next to "Excel Form" and select "Disconnect and Sync to New Workbook"

I hope these suggestions have been helpful to you!

Looking forward to your reply.

Best regards

Adrian.C-MSFT | Microsoft Community Support Specialist

Was this answer helpful?

1 person found this answer helpful.
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-01-10T08:39:40+00:00

    Same here. We also have the same situation. I have gone trough all the steps above and also tried with Chrome and Edge all the steps. The form is in a Team. I am owner of the team and also I granted Full Access on SharePoint workbook side.

    Please provide support !! !! !! !!

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2025-01-09T13:18:55+00:00

    Hi Adrian
    The solutions suggested above have not worked for me. I tried for a form I am an owner of and also tried with a user who is the owner of her form. The form data is saved to an excel file which is in a Team in which we both are Owners of, respectively. Any other suggestions for solving this issue?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2024-12-04T01:22:22+00:00

    Hi EmiHLC

    I am very happy that your problem has been resolved properly. You are awesome!

    In order to prepare for such problems in the future and to serve as a reference for other users, if you think my answer has some inspiration for you, you can select "Yes" or "No" for my previous reply underneath the post. Thanks for your cooperation.

    Have a good day!

    Best regards

    Adrian.C-MSFT | Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-12-03T13:54:34+00:00

    Good morning,

    I logged out and logged back in and that resolved the issue. Thanks!

    Was this answer helpful?

    0 comments