I'm using tabular form, no expand/collapse buttons, Repeating row lines. I indent by 1 the entire table by selecting the pivottable name in VBA. Everything looks great. After the macro is done and I filter a row item, the rows (not all of row items and none of the values) increase indent by another 1 space.

Does anybody have an idea how to preserve the indent levels of the entire table after I filter for this specific type of pivot table? I assume the indention problem lies with the repeating rows and/or no expand/collapse buttons in the way the items go from first in group to next. It seems like Excel would have a solution for it though - and it is not "Preserve Formatting" checkbox, nor is it "Indent for Compact Form".

Thanks for your ideas!