We help IT Professionals succeed at work.
Get Started

Getting Excel Web Access Web Part and filter Web Part to work togther

1,625 Views
Last Modified: 2012-06-27
Hello Experts,
We have a sharepoint site and there is a filter to filter the  contents of web parts using a list of values from SQL Server 2005 Analysis Services cubes.And there is one Excel Web access Web part used to display excel data. When I go to Modify shared web part for this Excel Web access web part  the Workbook tab points to an Excel sheet on site for example www.abc.com\xwz\PQ.xls.. But when I open this Excel sheet from the site where it is poining to which is XYZ\PQ.xls, It has different values then what is displayed on the site.

I have different sites , where this same excel sheet is refered to under Workbook tab for different Excel web access web part but it displays the data different for each Excel web part. I am unable to figure out where is this data coming from? There is a .odc connection to OLAP db on server but I am kind of lost to find if there are any tables under this OLAP DB and don't see any tables. This data has to be coming from a Excel sheet?? which may be I am unable to find. or its coming from OLAP DB? Please provide few suggestions how this Excel web access part works. Thanks
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE