Not sure if this is a known issue... I have a worksheet named "052011" with
this formula:
=INDIRECT("'"&E105&" "&MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
&"'!$D$18")
It allows me to reference another worksheet "N2I T2 052011" based on cell
E105 which contains "N2I T2".
This allows me to automate referring to other worksheets, and it seems to
work fine.
However, when this data is aggregated into a master table and I have a pivot
off that data, refreshing that pivot seems to make this formula return #REF!
instead of the right numbers. Yet, when I go back to the worksheet and
manually press enter on the formula, the #REF! disappears and the numbers
come back.
Is this a known issue and is there a workaround?
Thanks,
Andy
this formula:
=INDIRECT("'"&E105&" "&MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
&"'!$D$18")
It allows me to reference another worksheet "N2I T2 052011" based on cell
E105 which contains "N2I T2".
This allows me to automate referring to other worksheets, and it seems to
work fine.
However, when this data is aggregated into a master table and I have a pivot
off that data, refreshing that pivot seems to make this formula return #REF!
instead of the right numbers. Yet, when I go back to the worksheet and
manually press enter on the formula, the #REF! disappears and the numbers
come back.
Is this a known issue and is there a workaround?
Thanks,
Andy
