Can I have reference links in table's heads?
 

Hi,
I have excel 2007 and want to have a link formula in the head, like
"=Sheet2!Y3"
However, either it convert it to a zero "0", or it convert the formula
to a string.

How can I solve this? I have pivots connected to the table, but I
already done code to change them to a new head in the table. It's the
table that I can't deal with.

If I record the Excel user interface, it give me:
Sub Makro5()
Range("TAB_EffectValues[[#Headers],[Quality]]").Select
ActiveCell.FormulaR1C1 = "Categories"
Range("D4").Select
End Sub

If I try to run the macro again (but switch the words first), I get
error:
"method "range" error in object "_global" failed". Can't tell why.

I have tried with adapt it to VBA better, but of no use:

cnBusinessBenefits.Range("TAB_EffectValues[[#Headers],
[Quality]]").FormulaR1C1 = "Categories"

And I get an error if I try with a string variable in the VBA: "..
[Quality] .." - ".. [str1] .."

Any suggestion? Is the only way to convert it to an ordinary cell area
and then create the table again (all the formats in my table had to be
reconstructed in that case?

If you have any solution to this, I'd be very grateful!

Regards
Tskogstrom