Share this article
Improve this guide
We’re Having Trouble Connecting to the Server [FIXED]
Prevent server connection errors by erasing your browser cache ?
4 min. read
Updated onOctober 4, 2023
updated onOctober 4, 2023
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Key notes
There was a problem connecting to the serveris an error that can appear when Windows SharePoint Services and Excel are preventing the Excel spreadsheet from being imported correctly into Windows SharePoint.
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.
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 pressingCtrl+Uwhile 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.
-
Launch Microsoft Excel.
-
Open the file that you have trouble importing.
-
Navigate to theFile tabfrom the menu.
-
Go toAccount.
-
Scroll down toConnected Services. Here you can see which services you have associated to your account.
-
Remove the currently connected service.
-
After, click onAdd a service.
-
ChooseOther sitesfrom the list of options.
-
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.
More about the topics:Excel,windows 10 fix
Madalina Dinita
Networking & Security Specialist
Madalina has been a Windows fan ever since she got her hands on her first Windows XP computer.
She is interested in all things technology, especially emerging technologies – AI and DNA computing in particular.
Prior to joining the WindowsReport team, she worked in the corporate world for a number of years.
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Madalina Dinita
Networking & Security Specialist
Madalina is a Windows fan since forever, especially interested in AI, emerging technologies, privacy, and security.
