I have created a sharepoint list which may contain hundreds of line items. I have exported the list file to .iqy in order to connect it to excel.
In excel, I enabled the enable background refresh and refresh data when opening in the connection properties. In this way, any updates on the sharepoint list would appear to my excel file.
What I am try to acheive:
Is it possible that whenever I edit the excel file, it would also update the sharepoint list?
Whenever I update the excel file, it doesn't update the items in sharepoint list. It just updates the excel file based on the changes in the sharepoint list itself.