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

A

alwayslearning

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
 
S

Sarang

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...
 
S

Sarang

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
 
A

alwayslearning

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...
 

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

Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
pivot table missing rows? 0
Create a dynamic master file 1
Embed the same Excel multiple times 0
Pivot table 0
Survey into Pivot Table 1
Multiple charts from Pivot Table 0

Top