to copy pivot table as new sheet with same format

  • Thread starter Thread starter pol
  • Start date Start date
P

pol

How I can copy a pivot table to another worksheet without missing its format.
But in the new worksheet should behave as normal sheet can possible to insert
a new column , delete a column . Please kindly request ur advice

Pol
 
Select the entire table, copy, and pasted keeping the source formatting in a
new worksheet.
 
I did copy keeping source , But I cannot insert a new column on the new
worksheet.
How I can insert a new column on that new sheet

With thanks
Pol
 
You can't insert a column because you copied & pasted the pivot table as a
pivot table. Copy & paste the table you just pasted on the new sheet in place
as values. Then, unless you have no unused columns or an exotic problem
involving hidden objects, you should be able to insert a new column.

Hope this helps,

Hutch
 
Back
Top