Excel 2010 Pivot Help

Hi, all. I have looked through the other posts and can't find anything obvious that answers my question so hopefully someone with better knowledge than me (not difficult) can answer so an idiot like me can understand.

I have a document in Excel 2010 with around 15 - 20 pivots, from around 5 or 6 different data sources so I am controlling the dates using Slicers so I dont have to change all the dates in each pivot.

However, I may wish to add more pivots from different data sources which means more Slicers and things will start to get messy...


What I was hoping for was that I could have a drop down of the dates somewhere so each Pivot can read that so I am only changing one thing instead of the 5 / 6 / 7 / 8 (or however many I end up with) Slicers. Sadly it's not as simple as sticking "=" and then the cell.

Can it be done? If yes does anyone know how? And more importantly can you put it into terms that a simpleton like me will understand?

Many thanks in advance.

Andy

Hi,

Can you please attached sample file, so i can help you.

Imran.

Hi.

Does it really need a sample file? Don't know if my ignorance is making me miss something but if the filter for a pivot is for the date and is in cell B2 instead of changing that filter to change the date I want to change cell B3 (say) and have the pivot read that to change its date.

Sounds simple really but I still cant figure it out

hi,

Please attached sample file then i will be help you

Imran.