Cannot refresh a PivotTable report until the refresh operation for the external data range on which the report is based is ...

Cannot refresh a PivotTable report until the refresh operation for the external data range on which the report is based is complete.

Wait until the spinning world icon no longer appears in the status bar, click a cell in the report, and then, with the PivotTable report selected, on the Options tab, in the Data group, click Refresh.