Microsoft Developer Network > SharePoint Products and Technologies Forums > SharePoint - Excel Services > I cannot find Excel Web Access webpart

I cannot find Excel Web Access webpart

Tuesday, December 16, 2008 1:38 PMVarunChandra

0
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!
- Reply
- Quote

Answers

Tuesday, December 16, 2008 2:43 PMMadhur AhujaMSFT

0
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
- Edited byMadhur AhujaMSFTTuesday, December 16, 2008 2:44 PMremoved css
- Marked As Answer byVarunChandra Friday, January 30, 2009 9:14 AM
- Reply
- Quote

All Replies

Tuesday, December 16, 2008 2:44 PMMadhur AhujaMSFT

0
Oops. ignore the embedded CSS ...

--
Madhur

http://blogs.msdn.com/mahuja | Please mark the replies as answers if they help
- Reply
- Quote
Wednesday, December 17, 2008 6:10 AMMike Walsh MVPMVP, Moderator

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

Moving this there.
- Reply
- Quote
Monday, December 22, 2008 1:32 PMVarunChandra

0
Please elaborate on your suggestion. Where (in which file) should I copy the xml text?
- Reply
- Quote
Monday, December 22, 2008 2:02 PMMadhur AhujaMSFT

0
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
- Reply
- Quote
Friday, January 02, 2009 11:38 AMVarunChandra

0
Thanks Madur!
got it working following your solution..
- Reply
- Quote
Friday, January 02, 2009 11:40 AMMadhur AhujaMSFT

0
Glad that it worked for you!

--
Madhur

http://blogs.msdn.com/mahuja | Please mark the replies as answers if they help
- Reply
- Quote
Thursday, May 07, 2009 4:25 PMAndre Galitsky

0
Madhur's solution worked for me as well.
Andre Galitsky, MS-Certified SharePoint Administrator, Minneapolis, MN -- My SharePoint Blog: http://www.sharepointnomad.com
- Reply
- Quote

Need Help with Forums? (FAQ)