1. Navigate to this article:
Update to enable TLS 1.1 and TLS 1.2 as default secure protocols in WinHTTP in Windows
2. Scroll down to the Easy Fix section.
3. Select Download, and follow the instructions to install.
4. Once the file is installed, restart Excel and then try to refresh data.