SharePoint 2010 export to excel:Cannot connect to server at this time

Question

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.

Add SP-server (URL Root collection) to Local Intranet in settings IE. Your file is create in 64 bit Office or 32? — Fox, Jan 31 '19 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. — SharePointer, Feb 1 '19 at 0:32

Lisa Chen MSFT · Accepted Answer · 2019-01-31 10:08:03Z

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.

1 Answer 1