If you receive an error "A problem occurred while connecting to the server. If the problem continues, contact your administrator." while opening or editing Microsoft Office files (common with excel), use the below steps to troubleshoot and fix the problem.
This applies to all SharePoint on-premise (2007, 2010, 2013, 2016, 2019) and SharePoint Online (Microsoft Office 365) versions. Not actually a SharePoint problem, but an MS Office desktop client.
The problem is mostly user specific, device specific to be precise, and occurs while editing files.
While opening the excel, users may see a message like Server Read-Only - The document was opened from a server in read-only mode.
SharePoint Excel error - problem occurred while connecting to server
Troubleshooting and fixes
- Check "Web Client" service is enabled and in running state. Start --> Services --> Web client --> Properties --> set startup type to Manual --> Ensure its in running state.
- Clear Office cache from your device (laptop/desktop). Reboot if necessary. Path varies based on installed MS Office version, but something similar to C:\Users\%username%\AppData\Local\Microsoft\Office\16.0\OfficeFileCache
- Verify SharePoint permissions - Ensure the user has minimal edit/contribute rights to the file.
- Verify SharePoint Document Library setting "Require documents to be checked out before they can be edited ?" SharePoint Document Library --> Library Settings --> Versioning Settings --> check out settings.
- Delete the file from SharePoint document library and re upload. This fix works for many users.
- Restore moved document - if you moved the document from one library/folder to another, try restoring to original location and check the behaviour.
- If you created a Z: drive using "Add a network location", option, try deleting and recreating it.
Some additional troubleshooting tips which may help
- Clear browser cache/history.
- Reboot the machine.
- Check the behaviour from a different device.
- Try adding the link to trusted sites from browser.
More Posts related to SharePoint,
- error CAML Query containing special characters
- [Solved] SharePoint Illegal operation attempted on a registry key that has been marked for deletion
- Trigger Flow on selected Listitem from SharePoint view - create button with JSON column formatting
- SharePoint Excel error - The workbook cannot be opened because it contains the following features that are not supported by Excel in the browser
- Send Email with attachment using SharePoint PowerShell, SMTP server
- How to show or hide columns in SharePoint Online List Library from
- SharePoint excel error - A problem occurred while connecting to the server. If the problem continues, contact your administrator.
- How to get SharePoint Online user details from person or group column using REST API
- How to get SharePoint List Item URL using PowerShell
- How to get the SharePoint Tenant Login URL
- Special character & not working with SharePoint REST API
- How to disable SharePoint subsite creation option for owners
- Managed Metadata error - The data returned from the tagging UI was not formatted correctly
- Deploy SharePoint wsp solution package using PowerShell
- How to create classic site in SharePoint Online
- See actual SharePoint error exception modify web.config
- 'Edit Document' Requires a Windows Sharepoint Services-compatible application and Microsoft Internet Explorer 6.0 or higher
- How to enable anonymous public access for SharePoint Online site collection, file, folder without login ?
- SharePoint installation error - Setup is unable to proceed due to the following error This product requires Microsoft .Net Framework 4.5
- How to add animated Gif to SharePoint Online Page
- [Solved] SharePoint Search Internal server error exception
- How to create SharePoint Document Library
- SharePoint - Use Today's Date Time in list view filter and calculated column
- How to redirect SharePoint Site Collection to different URL
- SharePoint error cannot connect to the configuration database
More Posts:
- Change battery percentage in Android Emulator - Android
- Facebook | Error : Sorry, something went wrong We're working on it and we'll get it fixed as soon as we can - Facebook
- Git Remove Untracked Files using Command - Git
- How to Exit a File in Terminal (Bash/Zsh) - Linux
- Notepad++ Replace space with Dot - NotepadPlusPlus
- [Solution] Installing Whatsapp There's insufficient space on the device - WhatsApp
- Java Program to generate random string - Java
- Open VS Code Command Palette using Keyboard Shortcut - Shortcuts