Working with Slicers in older versions of Excel

[e119687]

I created a beautiful analysis dashboard using slicers only to find out that not everyone in the company has Excel 2010 or higher.

Users with 2010 or greater will see this:

When those less fortunate try to use the dashboard, they are presented with this view:

Is there an easy way to make a similar dashboard or the less fortunate?

 

[bobhc]

You say the less fortunate, but don't say what the poor sods are shackled too.
Slicers are designed only for 2010.............But there are ways of getting them to work in 2007, anything before that forget, it.

 

[e119687]

You say the less fortunate, but don't say what the poor sods are shackled too.
Slicers are designed only for 2010.............But there are ways of getting them to work in 2007, anything before that forget, it.

I believe the oldest version we have will be 2007. I would love to hear how to get them to work for 2007.

 

[bobhc]

There are some examples on google, perhaps this link will help,...but you must realise you are never going to get the slicer as 2010.

Try this for ideas

.