Fix Excel SharePoint Connection Errors When Editing a Workbook
Question details
A user needs to open and edit a SharePoint workbook in the Excel desktop application without a server connection error.

- Product
- Microsoft Excel desktop and Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- A user opens a SharePoint workbook in desktop Excel after confirming that browser editing works.
- Observed behavior
- Excel displays “We're having trouble connecting to the server,” while the workbook can still be edited in a browser.
Confirm that the affected user can open and edit the same workbook in SharePoint in a browser. The credential-clearing steps below apply to Windows; have the user's Microsoft 365 sign-in details available.
Clear stored Office credentials and sign in again
Use this Windows fix when the problem affects one user in desktop Excel but browser editing works.
Close Excel and other open Office applications on the affected user's computer.
In Windows, open Control Panel and go to User Accounts > Credential Manager > Windows Credentials.
Find entries clearly associated with Microsoft Office or the affected Microsoft 365 account, expand each entry, and select Remove. Leave unrelated credentials in place.
Start Excel, sign in with the affected work account when prompted, and open the workbook again from its SharePoint location.

Check the SharePoint workbook location and update Office
Use these checks if clearing credentials does not resolve the connection error.
Edit Excel-Compatible Workbooks with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for Excel formats, making it easy to move between applications. It can edit a permitted local copy of a workbook, but it does not fix Microsoft Excel's SharePoint connection error.
- 1. Download a permitted copy: In the SharePoint document library, select the workbook and choose Download, if your organization's permissions allow it.
- 2. Open it in WPS: In WPS Spreadsheets, select Open and choose the downloaded workbook.
- 3. Save your changes: Use File > Save to save the edited copy. Follow your organization's process for uploading changes to SharePoint, and check for newer edits before replacing a shared file.

Frequently Asked Questions
Why can I edit the workbook in a browser but not in desktop Excel?
Browser and desktop sessions can use different stored sign-in information. Stale Office credentials may affect desktop Excel even when the browser session works.
Where do I remove stored Office credentials in Windows?
Open Control Panel > User Accounts > Credential Manager > Windows Credentials. Expand entries clearly associated with Office or the affected Microsoft 365 account and select Remove.
What should I try if clearing credentials does not work?
Open the workbook directly from its SharePoint library using Open > Open in app. Then check the account and Office updates under Excel's File > Account menu.
Can I keep working while the desktop connection is being fixed?
If browser editing works, open the workbook from the SharePoint document library and continue editing it in the browser.




