• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

Link Pivot Table in Word from Excel

Hi there,
I need to copy a pivot table from Excel, past it to Word and keep the link in a way that when the Pivot table changes (Expands or shrinks as well as data inside it), the modifications are replicated in Word.

The main problem when I tried this is that the size does noy update when you make changes in Excel, for example by expanding the Pivot table.

The office version I am using 2010.

Any idea
0
racineconde
Asked:
racineconde
1 Solution
 
viralypatelCommented:
0
 
racinecondeAuthor Commented:
This is what I tried yesterday but it doesn't work. After copying the pivot table in word, when you extend it in excel it sort of extends in word but only for the first 2 or 3 rows.

Actually I don't know if the instructions are complete because they're saying that "You should see a note or an icon showing you that the pivot table has been copied to the clipboard" and I just haven't!!!
0
 
ScriptAddictCommented:
So,  I just copy it as normal, and in the word option I right click and select paste, and the scroll over and use one of the linked options.

The select in the table options this checkmark.  

I haven't found that it's perfect, but I think it's as good as you get. Selection box in 2010
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
racinecondeAuthor Commented:
I've requested that this question be deleted for the following reason:

ss
0
 
racinecondeAuthor Commented:
I don't need the answer to this question anymore.
0
 
ScriptAddictCommented:
Just go to word.  insert an embedded excel worksheet and copy paste it over.  
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
 
racinecondeAuthor Commented:
I've amended my comments. can we move on???
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now