Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-13-2020, 09:21 PM
Cantora Cantora is offline Please Help: Linking pivot tables from excel Windows 10 Please Help: Linking pivot tables from excel Office 2019
Novice
Please Help: Linking pivot tables from excel
 
Join Date: Jan 2020
Posts: 6
Cantora is on a distinguished road
Default Please Help: Linking pivot tables from excel

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}
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please Help: Linking pivot tables from excel Pivot Tables lilita123 Excel 1 04-01-2017 02:24 PM
Excel 2013 VBA for Pivot Tables galkej Excel Programming 0 03-07-2016 10:13 PM
Pivot Tables MSA5455 Excel 2 02-03-2015 06:02 AM
linking Excel pivot into PowerPoint formatted nhegler PowerPoint 0 11-22-2010 08:05 AM
Linking Excel Pivot Tables in a Word Document wmarsh3561 Word Tables 0 11-17-2009 06:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft