| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Create new file with ONLY certain data - Excel 2003 | Excel Worksheet Functions | |||
| Pivot table turning static in Excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table Data Source external excel file | Excel Discussion (Misc queries) | |||
| Making a pivot table report static. | Excel Discussion (Misc queries) | |||
| save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
Hybrid Mode
