Microsoft KB Archive/838048

= &quot;Data provider or other service returned an E_FAIL status&quot; error message when you export a document library in Windows SharePoint Services to an Excel workbook =

Article ID: 838048

Article Last Modified on 9/26/2007

-

APPLIES TO


 * Microsoft Windows SharePoint Services

-





SYMPTOMS
When you connect to a document library in a Microsoft Windows SharePoint Services Web site, and then click Export to spreadsheet to export the list of documents in the document library to a Microsoft Excel workbook, you may receive the following error message:

Data provider or other service returned an E_FAIL status.

When you click OK on the error message, the workbook is empty. The list of documents in the document library are not imported to the Excel workbook.



CAUSE
This issue may occur if you are running Microsoft Excel 2002. Although you can export a document library from a Windows SharePoint Services Web site to a Microsoft Office Excel 2003 workbook, you cannot export a document library from a Windows SharePoint Services Web site to an Excel 2002 workbook.



WORKAROUND
To work around this issue, modify the query and then import the data into Excel 2002. To do this, follow these steps:
 * 1) After you receive the error message that is mentioned in the &quot;Symptoms&quot; section, click OK.
 * 2) On the Data menu, point to Import External Data, and then click Edit Query.
 * 3) Click the yellow arrow icon next to each item that you want to import. When you click a yellow arrow icon, the icon changes into a check mark icon.
 * 4) Click Import.



MORE INFORMATION
For more information about Windows SharePoint Services, visit the following Microsoft Web site:

http://technet.microsoft.com/windowsserver/sharepoint/bb684453.aspx

Keywords: kberrmsg kbnofix kbbug KB838048

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.