Forum Discussion
Forms responses missing when Excel is opened
Dear Forms customers,
Forms for Excel contains a live data connection to your form. Any new response data will be stored in your form, and also be reflected in your workbook. On occasion, the workbook may not contain the latest data for a number of reasons.
If this is the case, Forms provides a new feature, "Sync all responses to a new workbook", in order to “sync” your most recent responses to a new workbook. This new workbook will be stored next to your original workbook on OneDrive for Business or SharePoint Online. This will ensure your data is up to date. Learn more about how to get missing data.
Regards,
Zhongzhong
Hi Zhong ZhongZhongzhong_Li
My sharepoint form was created using Form for Excel in Folder A, which means that the responses from the Sharepoint form syncs to an excel file. However, I need to move this excel file to another folder, lets call is Folder B.
When I move the excel file to Folder B, new responses to the form does not go into the excel file anymore. The best solution I managed to find so far is to use the option "sync all responses to a new workbook"to a new excel file. But the new excel file is again created in Folder A instead of Folder B.
Is there any solution or way to relink the excel file to the Sharepoint form after I moved the excel file? Pls let me know urgently. Thanks!
MicrosoftRele_2018 we use FileID to identify the file in SharePoint. If folder A and folder B are in the same SharePoint site, then you should be free to move the file, and the data sync connection keep working. If you met problem, please let me know, it should be a bug.
However, if folder A and folder B are in different SharePoint sites, we don't have good solution here (you could sync data into another workbook via Flow).
"Sync data to a specific file" is in our backlog. But I'm not sure if x-site file is in the scope.
Hi ZhongZhong
Folder A and B are different document libraries created under the same Sharepoint site (Team site).
- Zhongzhong_Li
Rele_2018, could you send me the form URL?
I am having this issue too.
I have created a form here: lishi.org/confirm-your-booking
linked to an excel spreadsheet
and I have set up a Zap to export the info to Gist and to Airtable
The data is being Zapped to Gist and Airtable but I cannot see it in the spreadsheet.
How can I view the data from the form in the spreadsheet?
Thanks
- Zhongzhong_Li
