Tuesday, September 4, 2007

cannot find Excel Web Access webpart in the gallery


While trying to drag drop the webparts, can not find the 'Excel web access' webpart in the list.

  1. copy paste the following code into a note pad and name it as 'ExcelWebAcces.webpart'.
  2. upload the 'ExcelWebAcces.webpart' file into the 'webpart gallery (Site Actions -> Site Settings -> webparts)

<?xml version="1.0" encoding="utf-8" ?>   
<WebPart xmlns="http://schemas.microsoft.com/WebPart/v2">  
<Assembly>Microsoft.Office.Excel.WebUI, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Assembly>   
<Title>Excel Web Access</Title>   
<Description>Use the Excel Web Access to interact with an Excel workbook as a Web page.</Description>