Hi,
Were you ever able to get this to work? If not, I have two ideas, though please note I am writing this reply on my cellphone and don't actually have excel open in front of me, so it is from memory.
1) Using only a pivot table linked to the data table.
i) While on the data table, create a summarized pivot table.
ii) Add all columns to the pivot table in the order you want.
iii) While clicked on the pivot table, select the right most menu (second of the pivot table menus).
iv) Change the pivot to be in tabular format, so the data looks more like a data table.
v) On the first pivot table menu, disable the +/- ability.
2) Using a macro that applies changes made to a pivot table slicer to a data table.
I) I have a macro at work that I found somewhere else and I made some changes to. If this would be of any benefit, I could create a dummy spreadsheet and attach here.
Hope this finds you well.
Jeff
