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


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)


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.


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.

ID do Artigo: 288228 - Última Revisão: 23 de abr de 2002 - Revisão: 1