- Check the Data Connections
– Check if the data source is correctly specified in ‘Data Connections’ and that you have permission to access. - Inherit DataConnections in workbook
– If the data connection already exists in another workbook, try to inherit the data connections from the former workbook. - Reconnect
– It is possible to reconnect or edit the data connection in ‘Data Connections’. Try to reconnect. - Disable Automatic Calculation
– Check the Excel Settings if the ‘Automatic Calculation’ is enabled. If it is enabled, disable it and save the changes. - Refresh Data Connection
– Try to click the ”Refresh Data” button to get the updated info.
