Pivot Tables disconnect

E

Edi151

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

Dave Peterson

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.
 

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

Top