Thursday, February 23, 2012

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

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.

1 comment:

  1. Hi Zosh, I was struggling with this issue for past one week and your above post work perfectly fine. Thank you for helping me in fixing this issue.

    ReplyDelete