link to pivot-table
 

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..

:)
--
oldLearner57