STS: "An Unexpected Error Has Occurred" When You Import Excel Worksheet List (288228)



The information in this article applies to:

  • SharePoint Team Services from Microsoft

This article was previously published under Q288228

SYMPTOMS

When attempt to import a Microsoft Excel worksheet into a SharePoint team Web site, you receive the following error message:
An unexpected error has occurred (-2147215003)

CAUSE

Microsoft Visual Basic for Applications was not installed with Office XP.

SharePoint Team Services relies on Visual Basic for Applications, when Microsoft Excel is opened, to select the range of cells to import into the list.

RESOLUTION

To resolve this issue, follow these steps.

NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
  1. Click Start, point to Settings, and then click Control Panel.
  2. Double-click Add/Remove Programs, and then select Add/Remove Features.
  3. Under Office Shared Features, click Visual Basic for Applications, and then select Run all from my computer.

Modification Type:MajorLast Reviewed:4/23/2002
Keywords:kbprb KB288228