to copy pivot table as new sheet with same format

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
 
G

Gilbert

Select the entire table, copy, and pasted keeping the source formatting in a
new worksheet.
 
P

pol

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
 
T

Tom Hutchins

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table date format 1
copy a pivot table to another sheet in a macro 1
Pasted Pivot Table looks at old sheet 1
Pivot Table - Changes 5
Source to Pivot Table 1
about pivot table 1
Pivot Table 1
Pivot table drill down data 2

Top