I cannot find Excel Web Access webpart

Question

I am unable to see the ExcelWebAccess web part in the list of Web parts available. I tried to add a new webpart in the webpart Gallery section but I do not get the Excel Web Part listed there. 

I have a MOSS SP1 farm with 2 Web Front Ends, 1 Application Server (with Excel Calculation Services started) and 1 Database server.

I have activated the following Site Features:
1. Office SharePoint Server Enterprise Site features
2. Office SharePoint Server Publishing
3. Office SharePoint Server Standard Site features

In the populate Web Part gallery page, i get two weird options: ExcelWebRender and InternalEWA - these have the same dll as the ExcelWebAccess.webpart (which i do not see) - Microsoft.Office.Excel.WebUI...

Am i missing out on some property/change/configuration?

Any help would be appreciated!

Answer 1

It looks like corrupted provisioning of site.

Try these steps:
 Copy the below text in a .dwp file and upload it into webpart gallery. You should see the webpart in the gallery.

<?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>

--
Madhur

---

http://blogs.msdn.com/mahuja | Please mark the replies as answers if they help

Answer 2

Oops. ignore the embedded CSS ...

--
Madhur

---

http://blogs.msdn.com/mahuja | Please mark the replies as answers if they help

Answer 3

Excel Web Access web part questions go to the excel Services forum.

Moving this there.

Answer 4

Please elaborate on your suggestion. Where (in which file) should I copy the xml text?

Answer 5

You copy it in notepad and save it with .dwp extension. Then upload this file into Site Settings - > Galleries - > Web Parts.

--
Madhur

---

http://blogs.msdn.com/mahuja | Please mark the replies as answers if they help

Answer 6

Thanks Madur!
got it working following your solution..

Answer 7

Glad that it worked for you!

--
Madhur

---

http://blogs.msdn.com/mahuja | Please mark the replies as answers if they help

Answer 8

Madhur's solution worked for me as well.

---

Andre Galitsky, MS-Certified SharePoint Administrator, Minneapolis, MN -- My SharePoint Blog: http://www.sharepointnomad.com

Answer 9

Madhur, I copied from the <?xml......... to the </WebPart> and uploaded the file (I called _excel.dwp) successfully, then I could see Excell Web Access in the Web Part list - BUT, when I tried to load that web part I got the message:

Unable to add selected web part(s).
Excel Web Access: The file you imported is not valid. Verify that the file is a Web Part description file (*.webpart or *.dwp) and that it contains well-formed XML.


What did I do wrong? Thanks in advance.