Prev: Hiding VB Code
Next: Plotting
From: pol on 5 May 2010 12:39
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
From: Gilbert on 5 May 2010 14:14
Select the entire table, copy, and pasted keeping the source formatting in a
new worksheet.

"pol" wrote:

> 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
From: pol on 5 May 2010 14:23
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

"Gilbert" wrote:

> Select the entire table, copy, and pasted keeping the source formatting in a
> new worksheet.
>
> "pol" wrote:
>
> > 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
From: Tom Hutchins on 5 May 2010 15:42
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

"pol" wrote:

> 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
>
> "Gilbert" wrote:
>
> > Select the entire table, copy, and pasted keeping the source formatting in a
> > new worksheet.
> >
> > "pol" wrote:
> >
> > > 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
 | 
Pages: 1
Prev: Hiding VB Code
Next: Plotting