Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
I've started to use power pivots and I'm finding it very frustrating![Oops! :banghead: :banghead:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f633.png)
<o
></o
>
The problem I'm having is as follows:<o
></o
>
I have several worksheets that I have imported via power pivot window which works fine. When I bring the pivot into excel and create a slicer for that table all the data changes as it should do but when I create a second / third table and try to link all together nothing happens?
<o
></o
>
I have tried to build the relationship build between them by using pivot table connections but it still doesn’t work.
<o
></o
>
I’ve also tried to use a second slicer and linking them but I don’t want two slicers identical to each other and when I delete it nothing works.
<o
></o
>
Help is needed before the laptop goes out the window.....
<o
></o
>
Thanks in advance....<o
></o
>
![Eek! :o :o](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
![Eek! :o :o](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
I've started to use power pivots and I'm finding it very frustrating
![Oops! :banghead: :banghead:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f633.png)
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
The problem I'm having is as follows:<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
I have several worksheets that I have imported via power pivot window which works fine. When I bring the pivot into excel and create a slicer for that table all the data changes as it should do but when I create a second / third table and try to link all together nothing happens?
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
I have tried to build the relationship build between them by using pivot table connections but it still doesn’t work.
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
I’ve also tried to use a second slicer and linking them but I don’t want two slicers identical to each other and when I delete it nothing works.
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Help is needed before the laptop goes out the window.....
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Thanks in advance....<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)