Linking an Excel Pivot table / cell range into Word

[Paul Dennis]

I can link an excel pivot table or a cell range into word and have it so it
auto updates but my problem is it the number of rows change then it doesn't
seem to reflect in the word doc - is there a way to resolve this?

 

[Brian]

I found a solution provided by Cindy that may help.

Cindy wrote:

Word pastes Excel links with a reference to the Sheet and the exact cell
range, in R1C1 syntax. Unlike Excel, Word knows NOTHING about relative cell
references; it's all absolute.

Best would be to assign a RANGE NAME to the table in Excel. After creating
the
link, Alt+F9 to display the LINK field code. change the Sheet#!R1C1 reference
to the range name. Alt+F9 again, then F9 to force the update. Now the link
should display everything that's contained in the range name. This can be a
problem if you add rows to the end of a table (outside the range border), but
as long as you insert them within the table, Word should pick them up. And
adding rows above the table won't cause any problems at all.

Hope this helps,

 

[Paul Dennis]

I created a named range for ="'StillOpen Breached'!$A5:$H"&COUNTA('StillOpen
Breached'!$A:$A)

which counts the rows and when viewed in Excel works fine.

When I change the link in word to the name of the above range it works, but
not when the range expands further than what was originally linked.