Tuesday, February 22, 2011

Another success story with Export to Spreadsheet Error

Recently I came across very weird issue of “Export to Spreadsheet” in MOSS 2007 list.

Here I am using word "weird"  because I did not find this issue related to IE settings.

When I click 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 my collogues were able to get this working.

Troubleshot the problem from multiple aspects and narrowed down the problem to machines/repro scenario 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.

No comments:

Popular Posts


The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.