Hey all,

I'm having an issue using the new pivot table slicers in Excel 2010. I have a total of 6 pivot tables all using the same data cube but displaying different things. I created a slicer to link all the tables together. Everything works fine until I try to connect the 5th pivot table. Excel then starts bouncing error messages to me saying it can't open the connection because that file is already in use.

Does anyone know how to connect more than 4 pivot tables to a slicer?