I am using Excel 2010. I am looking to have a final Excel file full of Pivot Tables reading from another file.
However I wouldn't like for the pivot tables to read everything from their data source: if possible, entire columns left out + possibility to filter inside a column by name.
I found a solution using Power Pivot, which would do all the filtering itself and be part of this final Excel file. One issue is that if your Excel version does not support the PowerPivot add-in, you won't be able to manipulate anything from the tables probably because the data source can't be read.
My goal is to be able to send that file to other users, without having to worry that: a) they are seeing some data I didn't want them to see b) they cannot manipulate themselves the file and play around with the pivot tables & c) I don't have to worry about them having PowerPivot or not.
Do you have any suggestions?
Thanks for the read & help anyways.