The message will prompt showing you a message like this: We’re having trouble connection to the server on Excel, if this keeps happening contact your help desk. This connection issue can be irritating for any user and it requires practical solutions that can ultimately solve multiple connection issues such as Excel trying to connect to server when saving. So, as troubling as this may be, we do have reliable solutions for you in this article.

Why is Excel not connecting to a server?

There are multiple causes that will generate Excel error connecting to the server, so be aware of the following ones to check them on your device: ➡️ Browser-related issues – It’s possible that your browser cache is corrupted or interferes with Excel processes. ➡️ SharePoint connection error – When using Excel to connect online, you should make sure it’s connected to SharePoint. ➡️ Connected services – You have multiple services connected to Microsoft Excel that may trigger server problems. That being said, you can solve Excel cannot connect to server with the right fix methods that we provided down below.

How to fix A problem occurred while connecting to the server Excel error?

1. Create a new list based on the Excel workbook

In the root site, we’re going to create a new list that is based on the Excel workbook. The last thing we’re gonna do is connect to the subsite, and then create a new list that is based on the new list template that you created.

2. Change Site Settings

For this, we’re going to disable anonymous access settings on the website in Windows SharePoint Services you’re using. Now we’re going to create a new list that is based on the Excel workbook. To see how to do that properly, follow the steps from the previous solution. Next, we’re going to configure anonymous access settings on the Web site in Windows SharePoint Services. SPONSORED

3. Use a ULS Viewer

ULS logs are created by Sharepoint whenever it’s processing a request. And the correlated log creates IDs for any specific request, which are very helpful when debugging a problem. This program allows you to view logs in real-time, simply by pressing Ctrl+U while running it. You can download ULS Viewer from Microsoft’s official website.

4. Manually connect the SharePoint Online Service

You can fix the Excel connection problem by modifying the connected services and manually connecting the SharePoint service. This can be done through the tool’s built-in settings, in the Account section.

  1. Launch Microsoft Excel.

  2. Open the file that you have trouble importing.

  3. Navigate to the File tab from the menu.

  4. Go to Account.

  5. Scroll down to Connected Services. Here you can see which services you have associated to your account.

  6. Remove the currently connected service.

  7. After, click on Add a service.

  8. Choose Other sites from the list of options.

  9. Add your Sharepoint Service.

We hope these fixes were of use. And in the meantime, let us know in the comment section down below what are your solutions.

SPONSORED Name * Email * Commenting as . Not you? Save information for future comments
Comment

Δ