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!!