SharePoint - How to control pivot tables (in Excel Web access webparts) from other webparts

Asked By cesar perez
16-Nov-09 01:04 PM
I am a new user of Sharepoint 2007.

I have published an excel spreadsheet in my SP2007 environment, that contains a pivot chart.

How can I do to control two variables of the Pivot Chart from two different webparts (each of these corresponds exactly with the same variable)?

My idea is to provide easy selection to other SP users to see on demand the different views of the pivot charts.
Thanks.




You can connect to two filter web parts using excel web access  You can connect to two filter web parts using excel web access

16-Nov-09 02:55 PM

You can use Filter Web Parts to pass values to the Microsoft Office Excel Web Access Web Part, and then change the view of data in the workbook based on the value:

for an How-to, check this: http://office.microsoft.com/en-us/sharepointserver/HA101054701033.aspx

 

  cesar perez replied to Alon Havivi
16-Nov-09 04:09 PM

Thanks for your quick response. I will follow the indications and then let you know. Regards, Cesar.

Create New Account
help
Setup MS Office SharePoint 2007 Test / Dev Environment Authentication Problems Hello all, i like to setup a fast clonable has dsiplay some warning, regarding the installation of MSSQL on a Domain Controller. My single SharePoint admin account is named SPAdmin (domain admin, mssql: security, dbcreator), the local domain ist named mistake, but currently I am reading the logfiles placed under "c: \ program files \ common files \ microsoft shared \ web server extensions \ 12 \ logs". I don't find any relavant information regarding authentication EXE, onetnative.dll) 03 / 04 / 2010 13:53:04.95 OWSTIMER.EXE (0x0980) 0x0988 Windows SharePoint Services Topology 0 Medium Diagnostics settings: 32768 03 / 04 / 2010 13:53:05.38 OWSTIMER.EXE (0x0980) 0x0988 Windows SharePoint Services Topology 9e7d Medium Initializing the configuration database connection. 03 / 04 / 2010 13:53:11 35 OWSTIMER.EXE (0x0980) 0x0988 Windows SharePoint Services Database 880i High System.Data.SqlClient.SqlException: Die von der Anmeldung angeforderte 'SharePoint_07_Config'-Datenbank ServerInfo serverInfo, Strin. . . 03 / 04 / 2010 13:53:11.35* OWSTIMER.EXE (0x0980) 0x0988 Windows SharePoint Services Database 880i High . . .g newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) bei System.Data
Inserting HTML in web page in Microsoft Office SharePoint design SharePoint How can I insert HTML in a web page created through Microsoft Office SharePoint. I used to do it with Front Page by copying it and paste it in want to use copy and paste in the web page I created in the program. SharePoint Discussions SharePoint (1) Front Page (1) Office (1) AEAC (1) Todd (1) CEWP (1) Add
sharepoint licensing SharePoint Dear Experts, I have confuse for sharepoint 2007 licensing. Microsoft Office SharePoint Server 2007, Server License: 1)Is this mandotory license to using other license? 2)Does "Microsoft Office SharePoint Server 2007 for Internet sites License" contain 3)If i purchase "Microsoft Office SharePoint
Microsoft Office Sharepoint Designer 2007 SharePoint Is Sharepoint Designer included in some versions of Microsoft Office? or a standalone product? - - Gale Pomper SharePoint Discussions SharePoint (1) Microsoft Office (1) SharePoint Designer 2007 is a standalone product. - - _ __ __ __ __ __ __ __ __ __ __ __ __ __ __ __ Asif
the right permissions on the content type. Then, I created a column "external data" in Sharepoint that I linked to my content type. When I want to change the data in EventID Level Message Correlation 11 / 13 / 2011 00:08:30.31 w3wp.exe (0x1D9C) 0x1038 SharePoint Foundation Monitoring nasq Medium Entering monitored scope (Request (GET:http: / / tricoflex:80 / CRM / _layouts / FldNewEx Cust%2E%20Relation%20ID&DescriptionParam = &VldFormulaParam = &VldMessageParam = )) 11 / 13 / 2011 00:08:30.31 w3wp.exe (0x1D9C) 0x1038 SharePoint Foundation Logging Correlation Data xmnv Medium Name = Request (GET:http: / / tricoflex:80 / CRM / _layouts / FldNewEx e307-4c5d-b470-c4351e5dff53 11 / 13 / 2011 00:08:30.32 w3wp.exe (0x1D9C) 0x1038 SharePoint Foundation Logging Correlation Data xmnv Medium Site = / 9694064f-e307-4c5d-b470-c4351e5dff53 11 / 13 / 2011 00:08:30.35 w3wp.exe (0x1D9C) 0x1038 SharePoint Foundation Monitoring b4ly Medium Leaving Monitored Scope (Request (GET:http: / / tricoflex:80 / CRM / _layouts / FldNewEx e307-4c5d-b470-c4351e5dff53 11 / 13 / 2011 00:08:30.45 wsstracing.exe (0x06A0) 0x17A0 SharePoint Foundation Unified Logging Service b9wt High Log retention limit reached. Log file 'C: \ Program Files \ Common Files \ Microsoft Shared \ Web Server Extensions \ 14 \ LOGS \ TRICOFLEX-20111030-0008.log' has been deleted. 11 / 13 2011 00:08:30.45 wsstracing.exe (0x06A0) 0x17A0 SharePoint Foundation Tracing Controller Service 8096 Information Usage log retention limit reached. Some old usage log