This error message usually occurs when Excel is unable to establish a connection with the external data source. Here are a few things you can try to resolve the issue:
- Check the data source: Ensure that the external data source is available and accessible. If the data source is a file, ensure that it is not open in another program.
- Check the credentials: Ensure that you have the correct credentials to access the external data source. If you are using Windows Authentication, ensure that you are logged in with the correct credentials.
- Check the firewall settings: Ensure that the firewall settings are not blocking the connection to the external data source.
- Test on another machine: Ensure if it is caused by data source side.