Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables disconnect
How do I make a pivot table stop being a pivot table?
I use Pivot Tables to sort and format data but need to change their final appearance for inclusion in reports. Also they only seem to copy as images not as editable documents when copied into Word doc files? Any advice wold be gratefully appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables disconnect
I select the pivottable range and just do
Edit|copy followed by Edit|paste special|values Actually, I copy the pivottable to a new sheet so I can work on a copy. After you have it as plain old data, open MSWord, then copy|paste the range of values. Edi151 wrote: How do I make a pivot table stop being a pivot table? I use Pivot Tables to sort and format data but need to change their final appearance for inclusion in reports. Also they only seem to copy as images not as editable documents when copied into Word doc files? Any advice wold be gratefully appreciated. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to disconnect the line for Internet? | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Disconnect linked file | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |