How do I save a pivot table as a static excel file?
 

I have created a pivot table. Now I want to copy that pivot table to another
file with just the data and format - just a regular file- no links to data
sources. How edo I do that? thanks

How do I save a pivot table as a static excel file?
 

"alwayslearning" wrote:

I have created a pivot table. Now I want to copy that pivot table to another
file with just the data and format - just a regular file- no links to data
sources. How edo I do that? thanks

How do I save a pivot table as a static excel file?
 

Hi,

1.Copy entire data from sheet containing pivot table
2.Paste in a blank sheet &
3.Paste values in the same sheet to remove the link

rgds

Sarang

"alwayslearning" wrote:

I have created a pivot table. Now I want to copy that pivot table to another
file with just the data and format - just a regular file- no links to data
sources. How edo I do that? thanks

How do I save a pivot table as a static excel file?
 

Thanks so much for your help! :)

"Sarang" wrote:

Hi,

1.Copy entire data from sheet containing pivot table
2.Paste in a blank sheet &
3.Paste values in the same sheet to remove the link

rgds

Sarang

"alwayslearning" wrote:

I have created a pivot table. Now I want to copy that pivot table to another
file with just the data and format - just a regular file- no links to data
sources. How edo I do that? thanks