• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel 2010 - Slicers [SOLVED]

ianb

ianb

Member
Hi, Just becoming familiar with splicers.


I can link together my pivot tables with splicers via a connections.


My question is this.


If I have connection1 = Access DB Data Set 1

Connection2 = Access DB Data Set 2


If the fields are the same name can I link these together if they are on different connections


for example field named : Date Month / Year


Else do you have another solution ?


Many Thanks.
 
Hi, ianb!

Each slicer operates on a unique pivot table, so if you have 2 PT you'll need 2 slicers.

Regards!
 
can I join Date Month / Year from each splicer if they are from different databases and show in different connections and are on different pivot tables ?
 
Hi, ianb!

Different PT, different slicers, ergo again not and each slicer is tied to its PT, in fact a slicer is an enhanced view of a normal filter for a PT field, so alike a filter it'd only display and let you select values that exist in that PT field.

Regards!
 
Thanks for the advise. have found a program that will sync pivot table fields. So that is my option.
 
Hi, ianb!

Glad you solved it. And if you want you can share that program (or info or links) with the community.

Regards!
 
You must log in or register to reply here.
Back
Top