Excel 2007 compatability mode for 2003- I have a list tab with text values in column C "ID" and a tab with a pivot table. The pivot table had 500,000 rows of underlying data. Based on the cell values of "ID" in column C(in each row), I would like to be able to see the underlying data of the pivot table for only the rows of underlying data where the uderlying data field "ID" matches the "ID" value in column C.

Note that the pivot table can not use the field "ID" becuase there are too many values and it can not represent those.

Also note that I need to be backward compatable to 2003.

I tried a hyperlink but am not sure how to reference the underlying data or how to programatically spawn the results.