link to pivot-table

O

oldLearner57

hi community

is there a work-around for this persistent problem...

I did a linked from a worksheet (workbook A) to another another workbook
(B) that contain a Pivot-Table.
and
whenever I opened up the
workbook (A), the linked cell did not reflect the actual value from the
workbook (B) pivottable,
it will only reflect the actual value when I open up the workbook (B) and do
a refresh in the Pivot Table
hope my explaination is clear
what I want is....
is there ways that I can see the actual value when I open workbook (A) and
not necessary open the workbook (B) - this contain the pivot table

thanks community for any assistance given..

:)
 

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

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Pivot table overlaps another pivot table - how to find it 0
Formula to Look up values from a pivot table 1
Excel 2007 pivot table using analysis services cube as data source 0
How to create absolue path link to another workbook (Excel 2003) 1
Cannot Open Pivot Table Source File 0
Pivot Table Counting Text Data 0

Top