how to create interactive link to a column in excel template pivot table?

[vanathi]

I need to apply link to a column values in the excel template pivot table.
In my requirement of bi publisher report. My report is based on excel template.
I have two sheets, one is base report(sheet 1) and another one is pivot report(sheet 2).The pivot tables(sheet 2) is created from the base report columns(sheet 1). I need to apply link to one of the column of pivot table for example, order_no column, if i click the particular order_no , it will open another report with respective of this order_no(as a parameter).
In the XDO_METADATA file i applied code for that.But the link only applies to the base report(sheet 1) Order_no instead of Pivot table(sheet 2) Order no. How to apply the link to the particular sheet(pivot table).
The XDO_METADATA file code
XDO_LINK_?ORDER_NO? -- http://vthamila-in.in.oracle.com:9704/xmlpserver/TEST/test2/test2.xdo?P_order_no=',./ORDER_NO)"/>
Excel version-2007
In tat above code- test2.xdo is my new report which have to open when clicking the order_no link.
i don't know how to specify link to the Pivot table(sheet 2).