0

While exporting any document library in a SharePoint 2010 web application , getting following error:

"Cannot connect to server at this time. Changes to your data cannot be saved."

Export to excel work fine in all other web applications in the same SharePoint 2010 environment.

Tried changing security settings in IE but no luck.

2
  • Add SP-server (URL Root collection) to Local Intranet in settings IE. Your file is create in 64 bit Office or 32? Jan 31, 2019 at 9:13
  • Thanks but this is also not working. There are folders in document library which contain documents but not sure which version were they created. Feb 1, 2019 at 0:32

1 Answer 1

1

Please follow the below steps:

Open Excel.

Go to "Data" tab from top menu.

Click on "From Web" from the menu items.

Connect your site with this.

Import the data.

Now go back to the IE and export List (which you were doing previously).

The List will be exported.

Similar issue post for your reference:

https://social.technet.microsoft.com/Forums/ie/en-US/c779151e-681b-4d5b-a43f-034c7f2b8bad/excel-cannot-connect-to-sharepoint-list?forum=sharepointgeneralprevious

1
  • I already tried this but still the same issue. Feb 1, 2019 at 0:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.