Export to spreadsheet error Sharepoint list

Posted: November 24, 2011 in Error on page, Excel, Internet Explorer, Office Issue, sharepoint 2007, Sharepoint 2010
Tags: , , ,
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

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