Pivot Slicers Backward Compatibility between Excel 2016 with Excel 2010

[b00gied0n]

Hi there,

I have a set of dynamic dashboards that are running from a set of pivot tables in version 2016. I sent the dashboards to my customer and they said they were not compatible with their Excel 2010. I tried the backward compatibility procedures that forces me to save my worksheet which is in .xlsx into the xls version from 2003. When I opened this new sheet, the problem is that my SLICERS in the front of my dashboard has all disappeared. A fellow analyst mentioned that this could be because the slicers werent invented yet in that earlier version. So I need help.

My objective: To share my workbook
My current problem: Slicers are missing when I make my worksheet backward compatible
Question 1: Using Excel still, how can I share my workbook with all the capabilities it requires including the graphs and the slicers and pivots and lookups without necessarily burdening the customer to upgrade to Excel 2016? I just need them to access the interface
Question 2: Can anyone recommend what's a platform that will allow me to show my dashboard, and for customers to interact with it that is not necessarily traditional excel. Again the limit is that it is a platform that doesn't burden my customers to buy the platform.

Thank you.

Don

 

[Jim Gordon]

.xls file format does not support slicers at all. They would probably work in 2013 just fine, but if your customer has 2010, the only option available is to update. Even Excel 2016 for Mac doesn't support slicers on charts or in Excel Tables, so it has to be Excel 2016 for Windows until the Mac version catches up. The features you want are not supported in the web version or mobile versions of Excel, either.