I am using SharePoint 2010 and excel from office 2016. When i give export to excel from the SharePoint site, it works fine and loads the data in excel first time. But when i try refresh the data, it shows error as below. "a connection to SharePoint site cannot be established. to synchronize or refresh your table, you much be able to connect to the SharePoint site."
Can anyone please help. All the service site settings are done and permissions are also set.