There was a problem connecting to the server Excel error [Fix]

Madalina Dinita
by Madalina Dinita
Managing Editor
0 Comments
Download PDF
Affiliate Disclosure

There was a problem connecting to the server Excel

There was a problem connecting to the server error can appear when Windows SharePoint Services and Excel are preventing the Excel spreadsheet from being imported correctly into Windows SharePoint. As troubling as this may be, we do have a few solutions for you.

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

  1. Create a new list based on Excel workbook
  2. Change Site Settings
  3. Use a ULS Viewer

1. Create a new list based on Excel workbook

In the root site, we’re going to create a new list that is based on the Excel workbook.

Ad

excel window There was a problem connecting to the server Excel

  1. On the home page of the root site, click Create.
  2. On the Create page, under Custom Lists, click Import Spreadsheet.
  3. Specify the options that you want, and then click Import.
  4. In the Import to Windows SharePoint Services list dialog box, click the range of cells that you want to use for your list, and then click Import.
  5. Specify the columns and the rows that you want to import, and then click Import.
  6. In the root site, save the new list that you created as a list template. To do so, follow these steps:
  7. In the root site, click Documents and Lists.
  8. Click the link to the list that you want to save as a template.
  9. Click Modify settings and columns.
  10. On the Customize ListName page, under General Settings, click Save list as template.
  11. In the File name box, type the file name that you want to use for the template file
  12. In the Template title box, type the title that you want to use for the template.
  13. Select the Include content check box and click OK.

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.

  1. Connect to the subsite, and then click Create.
  2. Click the template that you previously created.
  3. On the New List page, specify a name and a description for the list, and then click Create.
  4. You’re good to go now.

2. Change Site Settings

For this, we’re going to disable anonymous access settings on the website in Windows SharePoint Services you’re using.

  1. Go to the home page of the root site, next click Site Settings.
    web applications tab There was a problem connecting to the server Excel
  2. On the Site Settings page, click Go to Site Administration.
  3. Click Manage anonymous access.
  4. In the Change Anonymous Access Settings area click Nothing, then click OK.

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.

  1. On the home page of the root site, click Site Settings.
  2. On the Site Settings page, click Go to Site Administration.
  3. On the Top-level Site Administration page, under Users and Permissions, click Manage anonymous access.
  4. On the Change Anonymous Access Settings: SiteName page, in the Anonymous Access area, click Entire Web site or click Lists and libraries, and click OK.

3. Use a ULS Viewer

ULS logs are created by Sharepoint whenever it’s processing a request. And the correlated log creates IDs to 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.

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

RELATED STORIES TO CHECK OUT:

Ad
Was this page helpful?
Thanks for letting us know! You can also help us by leaving a review on MyWOT or Trustpillot.
Get the most from your tech with our daily tips
Tell us why!