PowerPivot - Create a useable pivot table for NON PowerPivot users 0
No (0) 0%
Yes (0) 0%
Poll ends on Jan 19th 2038, 3:14 am
Not sure if anyone is very familiar with using PowerPivot for Excel as I have searched the forums and didn't see much mention of it.
Anyway, it's an excellent tool and one that I have started to work with, however the major downfall for me is that most users of the tables I am generating will not have PowerPivot installed and thus won't be able to filter or perform other standard actions that they normally would on a regular pivot table.
So, I guess my question from a high level is...does anyone know how I can utilize PowerPivot to build my pivot tables, but then also be able to have other users who do not have PowerPivot installed still be able to use the pivot table as they normally would be able to.
Note: assume sharepoint, and purchasing/utilizing a powerpivot server are not acceptable solutions.