SharePoint Document Issues

Fix Excel SharePoint Connection Errors When Editing a Workbook

Emma BrownEmma Brown Nov 22, 2026 868 views

Question details

A user needs to open and edit a SharePoint workbook in the Excel desktop application without a server connection error.

Fix Excel SharePoint Connection Errors When Editing a Workbook
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.
Before you start

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.

Solution 1Recommended

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.

1
Close Excel

Close Excel and other open Office applications on the affected user's computer.

2
Open Credential Manager

In Windows, open Control Panel and go to User Accounts > Credential Manager > Windows Credentials.

3
Remove Office 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.

4
Sign in and reopen the workbook

Start Excel, sign in with the affected work account when prompted, and open the workbook again from its SharePoint location.

Clear stored Office credentials and sign in again
Sign-in may be required again: Removing stored credentials can require the user to sign in again to Office services. If you are unsure which entries belong to Office, ask your administrator before removing them.
Free Microsoft Office alternative

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. 1. Download a permitted copy: In the SharePoint document library, select the workbook and choose Download, if your organization's permissions allow it.
  2. 2. Open it in WPS: In WPS Spreadsheets, select Open and choose the downloaded workbook.
  3. 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.
Open and edit Excel-compatible workbooks in WPS SpreadsheetsCompatible with Microsoft Excel XLSX and XLS formatsFamiliar spreadsheet interface for an easier transition from ExcelFree, lightweight suite for everyday document editing
microsoft office alternative - wps office

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.