If this happens, first try and navigate to the Data tab in Excel and click the "Refresh from CRM" icon. If that doesn't work, try with the "Refresh All" option.
If this still doesn't work, then do as follows:
- On the Data tab click Connections to open the "Workbook Connections" window
- Click Properties
- Click the Definition tab
- Click "Edit Query"
- Enter your credentials
After authenticating do as follows:
- Click Ok on the Error window (after entering credentials)
- Click Cancel on the Edit Web Query window
- Click Ok on the "Connection Properties" window
- Click Close on the "Workbook Connections" window
After having performed these steps, try to refresh once again first using the "Refresh from CRM" icon and if that doesn't work, click "Refresh All" and your data should appear.
I am not currently aware of a permanent solution for this issue.