Cannot connect to the server at this time. Changes to your data cannot be saved Export to Spreadsheet

Posted: February 24, 2012 in Excel, Internet Explorer, sharepoint 2007

One of my colleague reported an issue with  “Export to Spreadsheet” in Sharepoint 2007 list. He was the only one who was getting this error message. So this was sure that this was a machine specific issue and has to do something with the IE settings.

When he clicked on one of the list it says “Cannot connect to the server at this time. Changes to your data cannot be saved” and at the same time i was able to get this working.

After some troubleshooting we found that,  when the SharePoint site had been accessed from Vista/Win7 clients with SSL (https) and with the local user account. Turned out that the problem was related to certificate revocation lists (CRLs) and had been an issue due to the following setting in IE: “Check for server certificate revocation” which is switched on by-default on Vista/Win7 clients as opposed to XP clients. When this IE switch got turned off, everything was working fine.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s