Tuesday, September 4, 2007

cannot find Excel Web Access webpart in the gallery

Situation:

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

Fix:
  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=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</Assembly>   
<TypeName>Microsoft.Office.Excel.WebUI.ExcelWebRenderer</TypeName>   
<Title>Excel Web Access</Title>   
<Description>Use the Excel Web Access to interact with an Excel workbook as a Web page.</Description>   
<FrameType>TitleBarOnly</FrameType>   
<PartImageSmall>/_layouts/images/ewr023.gif</PartImageSmall>   
<PartImageLarge>/_layouts/images/ewr023.gif</PartImageLarge>   
</WebPart>

1 comment:

  1. I do not see the whole Business Data Group when I go to add a web part. Surely this simple action would not resolve... But I am not a farm admin - I wonder if there are site features needing activation that I can not see.

    ReplyDelete