Hi All,

I have a monthly report that goes to the CIO to give a snapshot of everything that's going on in our team.

The reports include a lot of graphs which are linked to our working spreadsheet, so i can just open the report, CTRL+A and F9 and then send it on, but he's now asked that a more detailed breakdown be included under each graph in case he wants to review further.

I understand how to link the data so it can be updated, but I notice it fixes the range of rows. Is there a way to link to the pivot table itself, so when rows are added, it adds the rows in Word?

I am wondering if there's a specific code change to change it from a range to a named area.

EG instead of:

{LINK Excel.Sheet.12 "excel link address/filename.xlsx" "Sheet1!R21C1:R34C6" \a \f 5 \h \* MERGEFORMAT }

it is something like

{LINK Excel.Sheet.12 "excel link address/filename.xlsx" "Sheet1!PivotTableName" \a \f 5 \h \* MERGEFORMAT }

Anyone able to help me out here?


I saw on a different site these instructions. I could not follow these / understand how to make it work. each time i followed the instructions and changed the link name, it just said the link is broken.

Name the range, Sheet2!R1C1:R8C2, as an Excel table (Insert->Tables-Table). Let's call this tbSheet2

Create a name that points to the table(Formulas->Defined Names->define Name). Let call it sh2Table and point it to tbSheet2[#All]

Change the file code to the table name. With the example below, the change is:

{LINK Excel.Sheet.8 "C:\Users\myAccount\Documents\testexcel.xlsx" "Sheet2!**sh2Table**" \a \p}