I cannot find Excel Web Access webpart

Tue, 16 Dec 2008 13:38:58 Z

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!

I cannot find Excel Web Access webpart

Tue, 16 Dec 2008 14:43:51 Z

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

<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

I cannot find Excel Web Access webpart

Tue, 16 Dec 2008 14:44:24 Z

Oops. ignore the embedded CSS ...

--
Madhur

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

I cannot find Excel Web Access webpart

Wed, 17 Dec 2008 06:10:43 Z

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

Moving this there.

I cannot find Excel Web Access webpart

Mon, 22 Dec 2008 13:32:44 Z

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

I cannot find Excel Web Access webpart

Mon, 22 Dec 2008 14:02:43 Z

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

I cannot find Excel Web Access webpart

Fri, 02 Jan 2009 11:38:36 Z

Thanks Madur!
got it working following your solution..

I cannot find Excel Web Access webpart

Fri, 02 Jan 2009 11:40:03 Z

Glad that it worked for you!

--
Madhur

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

I cannot find Excel Web Access webpart

Thu, 07 May 2009 16:25:13 Z

Madhur's solution worked for me as well.

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

I cannot find Excel Web Access webpart

Mon, 09 Nov 2009 19:21:36 Z

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.