Pivot tables - I want to copy a pivot table to another worksheet. I know how to do this, however, when I copy or moved to a new worksheet the the rows that I have previously hidden appear. The format of my pivot table is in a Tabular form.
As I don't require the lines that I have previously hidden. is there a way of doing this without me deleting the individual rows that I don't want. In the old version I use to be able to copy a pivot table to a new worksheet without formulas from the
pivot table. Any assistant would be appreciated. thank you.