Column sorting, filtering, and layout changes are not being retained for this external data range. To retain these changes, ...

Column sorting, filtering, and layout changes are not being retained for this external data range. To retain these changes, click OK, and then on the Data tab, in the Manage Connections group, click the arrow next to Refresh All, and then click Refresh.