Prev: Excel pausing
Next: How do I arrange cells in alphabetical order in Excel?
From: srpd on 27 Jan 2010 17:00
Can this be done? I'll have several charts to go to several Word docs and
would like to avoid the copy/paste option.
From: RussellT on 28 Jan 2010 16:03
copy the pivottable to your clipboard. Open Word choose Edit, PasteSpecial.
On the Paste Special Window choose Paste Link and Microsoft Excel Worksheet
Object. Realize that this could cause you to have a very large Word doc.

"srpd" wrote:

> Can this be done? I'll have several charts to go to several Word docs and
> would like to avoid the copy/paste option.
From: srpd on 28 Jan 2010 17:56
Thanks for your help, but it's not the Pivottable I want to put into Word but
the PivotCharts. There will be 150+ and I was hoping for some sort of export
/merge mechanism. The data in the tables will not be in the final Word report.

"RussellT" wrote:

> copy the pivottable to your clipboard. Open Word choose Edit, PasteSpecial.
> On the Paste Special Window choose Paste Link and Microsoft Excel Worksheet
> Object. Realize that this could cause you to have a very large Word doc.
>
> "srpd" wrote:
>
> > Can this be done? I'll have several charts to go to several Word docs and
> > would like to avoid the copy/paste option.
 | 
Pages: 1
Prev: Excel pausing
Next: How do I arrange cells in alphabetical order in Excel?