Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking cell to Pivot Table data
I create a Pivot Table every month on one network drive and I link various
cells of the Pivot table into another worksheet on a different network drive. I've been doing this for several years and this month my formulas are not working properly. In the worksheet where I want to add the link, I hit the + sign and then click on the source worksheet Pivot Table cell that I want to link to. However, instead of showing the formula as (i.e.) =+'A:\foldername\[filename]tabname'!cell#, I am getting a formula that begins =+GETPIVOTDATA. This doesn't work for me because I need the formula to always bring the correct information when the worksheet is opened--the GETPIVOTDATA formula displays a #REF once the source file is closed. What caused this change in formula--and more importantly--how do I get my old formula back? -- Thanks so much! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking cell to Pivot Table data
Hi Steph,
When you type "+" to input the link to the spreadsheet that contains the Pivot Table, go to the spreadsheet and click on a cell that isn't within the table. Then use the back space button to delete the cell reference that you clicked on and type the cell reference instead. If that fails and you are pulling the same data every month try having the data on one sheet, the pivot on the next and make a "look up" where you can get the data to read into this sheet and the link to look at this page rather than the table itself. Hope this works. Clare "steph" wrote: I create a Pivot Table every month on one network drive and I link various cells of the Pivot table into another worksheet on a different network drive. I've been doing this for several years and this month my formulas are not working properly. In the worksheet where I want to add the link, I hit the + sign and then click on the source worksheet Pivot Table cell that I want to link to. However, instead of showing the formula as (i.e.) =+'A:\foldername\[filename]tabname'!cell#, I am getting a formula that begins =+GETPIVOTDATA. This doesn't work for me because I need the formula to always bring the correct information when the worksheet is opened--the GETPIVOTDATA formula displays a #REF once the source file is closed. What caused this change in formula--and more importantly--how do I get my old formula back? -- Thanks so much! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking cell to Pivot Table data
Hi
Debra Dalgleish has instructions on her site about how to switch on or off the GetPivotData function http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "steph" wrote in message ... I create a Pivot Table every month on one network drive and I link various cells of the Pivot table into another worksheet on a different network drive. I've been doing this for several years and this month my formulas are not working properly. In the worksheet where I want to add the link, I hit the + sign and then click on the source worksheet Pivot Table cell that I want to link to. However, instead of showing the formula as (i.e.) =+'A:\foldername\[filename]tabname'!cell#, I am getting a formula that begins =+GETPIVOTDATA. This doesn't work for me because I need the formula to always bring the correct information when the worksheet is opened--the GETPIVOTDATA formula displays a #REF once the source file is closed. What caused this change in formula--and more importantly--how do I get my old formula back? -- Thanks so much! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
linking cell to Pivot Table data
Thanks Roger. This worked perfectly. I just got a new machine at work which
may have contributed to the problem. But I don't remember having the GETPIVOTDATA button on the toolbar before. No matter, it's fixed and I have you to thank for it!! -- Thanks so much! "Roger Govier" wrote: Hi Debra Dalgleish has instructions on her site about how to switch on or off the GetPivotData function http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "steph" wrote in message ... I create a Pivot Table every month on one network drive and I link various cells of the Pivot table into another worksheet on a different network drive. I've been doing this for several years and this month my formulas are not working properly. In the worksheet where I want to add the link, I hit the + sign and then click on the source worksheet Pivot Table cell that I want to link to. However, instead of showing the formula as (i.e.) =+'A:\foldername\[filename]tabname'!cell#, I am getting a formula that begins =+GETPIVOTDATA. This doesn't work for me because I need the formula to always bring the correct information when the worksheet is opened--the GETPIVOTDATA formula displays a #REF once the source file is closed. What caused this change in formula--and more importantly--how do I get my old formula back? -- Thanks so much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking worksheets into a pivot table | Excel Worksheet Functions | |||
linking pivot table data to a cell in other sheet | Excel Worksheet Functions | |||
Pivot Table Linking | Excel Discussion (Misc queries) | |||
GETPIVOTDA - Linking Into Pivot-table Cell | Excel Discussion (Misc queries) | |||
Linking Combo box to pivot table? | Excel Discussion (Misc queries) |