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.

Export to spreadsheet error Sharepoint list

Issue

Whenever you try to export the sharepoint list to spreadsheet you get the following error in IE

WEB 1 _https://[Server]/[Site]/_vti_bin/owssvr.dll?XMLDATA=1&List={35667866-8224-44B2-8124-06F2254BEBB5}&View={35667866-8224-44B2-8124-06F2254BEBB5}&RowLimit=0&RootFolder=%2fD721%2fLists%2fDCR01 (_https://[Server]/[Site]/_vti_bin/owssvr.dll?XMLDATA=1&List={35667866-8224-44B2-8124-06F2254BEBB5}&View={35690566-82E4-44B2-8304-06F2254BEBB5}&RowLimit=0&RootFolder=/[Site]/Lists/DCR01) Selection={35667866-8224-44B2-8124-06F2254BEBB5}-{353450566-82E4-44B2-8304-06F2254BEBB5} EditWebPage= Formatting=None PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=False DisableDateRecognition=False DisableRedirections=False SharePointApplication=https://[Server]/[Site]/_vti_bin SharePointListView={35667866-8224-44B2-8124-06F2254BEBB5} SharePointListName={70AF7FCA-529D-4DD5-B018-222E1013C042} RootFolder=/[Site]/Lists/TEST

 Solution (2 ways to Solve this)

1.   Repair Office Version from  your machine -

http://support.microsoft.com/kb/924611

2.   Reset the IE to it original state

From IE - Tools - Internet Options - Advanced Tab - RESET

In the Reset Internet Explorer Settings dialog box, click Reset.

Restart IE and try exporting again.

Let me know if this doesn't help. Thanks

Export SharePoint Permissions to Excel

I have seen multiple requests from the users asking to Export SharePoint permissions to Excel Sheet. Now there is a way to export it from sharepoint 


To do this , you will have to Open Excel Sheet , Navigate to Data Tab – Click on "From Web", as shown in the below Screen shot





Once You click on that , it will bring up a New Web Query pop up Box, You will have to Enter the URL and Select the check boxes Highlighted in yellow to import it in Excel.





Select the desired users, Click on Import and Voila . All the users imported.


Hope this Helps.