linking cell to Pivot Table data


G

Guest

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?
 
Ad

Advertisements

G

Guest

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
 
Ad

Advertisements

G

Guest

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 said:
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 said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top