Thursday, November 24, 2011

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

No comments:

Post a Comment