Is it possible to send data from a Sharepoint list form to an excel file that is stored in Documentlibrary. If it is possible how should I do it? I couldnt find any tutorial on this matter.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
You can use the export to excel action in your desired list. It will download a query file. Open it and an excel file which has a data connection to your list will be created. Save the excel file and upload it to the library. The work is done.
When there are changes in the excel file, just refresh your data, it will update your workbook data.
Have a check on this article for detailed steps: https://sharepointmaven.com/export-sharepoint-excel/