Refresh the Excel table with revisions from the SharePoint list.
Imagine that by now others have added their information to the SharePoint list. You can, of course, look at the revised data in the SharePoint list. But if you want to, you can refresh the table in Excel so that you can also see the revisions in Excel, provided that you selected the read-only connection check box when you exported the list.
To refresh the data, on the Table Tools Design tab, in the External Table Data group, click Refresh. The data in Excel is updated.
A question arises here. People wonder if after refreshing and getting updates from a SharePoint list to Excel, can you then make changes in Excel and send your changes up to the SharePoint list? Sorry, it's not possible. The data can only be edited on the SharePoint site and refreshed in Excel, not the other way around. Or you can make changes in Excel and then export the table as a new SharePoint list, using a different name for the new list.
