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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
alwayslearning said:
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
Click to expand...
 
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
 
Thanks so much for your help! :)

Sarang said:
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
Click to expand...
 
Back
Top