Forms - Excel Workbook is missing

Question

Hi, I've tried to sync all Forms responses into a new workbook as the guide suggests.

However, I'm not able to open a new excel workbook.

Excel workbook is missing

If this workbook was deleted, you can get a new one. Learn more.

Technical details: Session id: 32c4b645-fc8c-4662-b7c0-e04e271abdb4, Correlation id: 6b24aad3-8d2c-4dfb-8583-ac7b7e77a687

I hope you can assist me.

Answer 1

Hello jmhoCU,

Ok, let's try this:

First, a little explanation about SharePoint and Teams, when you create a team in Microsoft Teams, it will create a SharePoint site with same name, each channel on the team will create a folder with same name in the SharePoint site.

So, you have to verify if the main library of the SharePoint site has an special conditions like required columns, the check in/out feature activated or the Approval feature, this features could create the conflict that you are facing.

Also, you have to verify if you have the right permission, basically you need to have an "Edit" permission level on the SharePoint library to create a new file there.

By other hand, when you click in "Open in Excel" button or the "Sync all responses to a new workbook" from the form to see all responses, immediately, the SharePoint library it will create an Excel file on the channel folder, I mean, if you have created the form in the "General" channel, the Excel file will be in General folder of the SharePoint library.

Answer 2

Dear Renzo,

Thanks for reaching out.

1. Yes, I am the owner of the form.
2. I created the form through a Microsoft Teams team.
3. No, I'am afraid I don't have the admin rights.

Answer 3

Dear jmhoCU,

I'm Renzo, I'll help you with your question.

In order to help you, could you kindly respond following questions?

1. Do you are the owner of the form?
2. Where do you have crated the form, directly from the Form website or from a Office 365 Group / or from a Microsoft Teams team?
3. Do you have an admin account from your Office 365 tenant?