Forum Discussion
Stephanie Piazza
Sep 14, 2017Copper Contributor
Forms responses missing when Excel is opened
I have created a Form in Office 365 Business and now have 81 responses. When I try to open the responses in Excel, it only shows that I have 1 response. Please advice.
- Apr 28, 2018
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
Zhongzhong_Li
Microsoft
Apr 28, 2018Dear 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
Rele_2018
Mar 21, 2019Copper Contributor
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!
- Zhongzhong_LiMar 21, 2019
Microsoft
Rele_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.
- Rele_2018Mar 21, 2019Copper Contributor
Hi ZhongZhong
Folder A and B are different document libraries created under the same Sharepoint site (Team site).
- Zhongzhong_LiMar 21, 2019
Microsoft
Rele_2018, could you send me the form URL?