Fix Network Errors Opening Excel Files in Windows 7 and 8
Question details
Users encounter a network error when attempting to open Excel files from SharePoint or OneDrive for Business in the desktop application.
- Product
- Microsoft Excel
- Device & OS
- Windows 7, Windows 8
- Scenario
- Opening cloud-hosted Excel files (SharePoint or OneDrive for Business) directly in the desktop application.
- Observed behavior
- The desktop application fails to open the file and displays a network error, which is typically caused by TLS 1.2 not being correctly configured or enabled in WinHTTP.
Ensure you have administrative privileges on your computer, as resolving this issue requires installing Windows updates and modifying system registry settings.
Install Update KB3140245 and Configure Registry
This is the primary solution for enabling TLS 1.2 in WinHTTP on older Windows operating systems to allow secure connections to cloud services.
Older versions of Windows rely on legacy security protocols by default. To connect to modern cloud services like SharePoint, you must manually enable TLS 1.1 and TLS 1.2.
Navigate to the Microsoft Update Catalog, search for update KB3140245, and download the version appropriate for your operating system.
Run the downloaded installer and follow the prompts to install the update. Also, ensure you install the latest supported TLS cipher suites.
Press Windows + R, type 'regedit', and press Enter. Navigate to the WinHTTP registry keys and add the 'DefaultSecureProtocols' value to enable TLS 1.1 and TLS 1.2 according to Microsoft's documentation.
Reboot your PC to apply the registry changes, then open your Excel application and attempt to access the SharePoint or OneDrive file again.
Use Microsoft's Easy Fix Tool
Use this automated tool if you have already enabled TLS 1.2 but continue to experience network errors.
Try WPS Office for a Seamless Spreadsheet Experience
If you are tired of dealing with network integration errors and legacy configuration issues in older versions of Microsoft Excel, consider switching to WPS Office. It provides a modern, fast, and completely free alternative for all your spreadsheet needs.
Frequently Asked Questions
Why does TLS 1.2 cause network errors on Windows 7 and 8?
Windows 7 and 8 originally defaulted to older security protocols (TLS 1.0). When modern cloud services like SharePoint and OneDrive mandate TLS 1.2 for better security, legacy desktop applications fail to connect unless the OS is manually updated to support the newer protocol.
Will upgrading my Windows operating system fix this issue?
Yes. Upgrading to Windows 10 or Windows 11 resolves this issue natively, as modern operating systems have TLS 1.2 and TLS 1.3 enabled by default, eliminating the need for manual registry fixes.
What should I do if the registry edit doesn't work?
If editing the registry and installing KB3140245 does not fix the problem, try running the Microsoft Easy Fix tool. Additionally, ensure that your firewall or antivirus software is not actively blocking encrypted TLS traffic.
