Upload the survey to an Excel spreadsheet
Open the file owssvr.iqy in Excel.
Save as. xlsx document.
On a new sheet make different formulas/calculations for the processing survey data;
Trying to update it (upload a new survey responses in an Excel file)
Get the error
Despite the fact that the data connection in the Excel document have and even actively
What am I doing wrong and how to Excel once again to make friends with Sharepoint? in 2013, SP everything worked without problems, but after upgrading to SP now 2016 issue(
Of course, the user who opens the Excel document has full access to the list (survey) to SP.