Forum Discussion
RossChevalier
Apr 08, 2021Brass Contributor
Location of Excel sheet holding Forms responses
Hello If a user creates a form and shares it, responses go to an Excel sheet that the user can access through Forms. Where SPECIFICALLY is the Excel file located, not from a country perspective ...
RobElliott
Apr 09, 2021Silver Contributor
RossChevalier the spreadsheet is stored somewhere on Microsoft's servers and you cannot access that location. If you want to share it without giving collaborate access just click on the Open in Excel link and then save it to your file system.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- RossChevalierApr 13, 2021Brass ContributorThank you for your reply. What is not clear is if I save the Excel file to my file system (One Drive or Teams share) if additions from new submissions will show up on the sheet now in the filesystem or if it becomes a static copy. If not, my issue remains open.
- ihubaySep 05, 2023Copper Contributor
RossChevalier Hello, I have the same question 2 years later. Were you ever able to solve the issue?
- DingkunXieSep 06, 2023
Microsoft
Check this KB, it depends on how you create your form, it may be stored as a local file or an online file in OneDrive/SharePoint.