Pivot Table drill down

[Guest]

Hi

One of my favourite parts of pivot tables is the fact that you can double
click on a value and it will drill down on it for you and open a new sheet
with the lines of the original data which make up that value.

However, the lines in the new sheet are text values (whereas the original
data is links to other spreadsheets). Is there any way to get it to show you
the links instead of just text?

It might just be a limitation of pivot tables.

Hope this makes sense!!

 

[Dave Peterson]

I think you're stuck.

But could you apply data|Filter|autofilter to the original table--then filter
based on the same rules that determined the value that you doubleclicked on in
the pivottable.