drilling down in pivot tables

[JimBobBillyJean]

Hello all...

I am using the drill down option in pivot tables whereby you can double click on a value in the table and it opens up a separate sheet with the information used to calculate the value. Only problem is that in the sheet that comes up, you loose all the formatting of the original information and things like hyperlinks don't come over. Is there anything I can do in order to get the sheet with the detail on it to come up with nicer\original formatting of cells?

Thank you

 

[OvationPlayer]

I would be interested if anyone has any clues to a solution to this. I have a sheet with cells that have hyperlinks. This sheet supplies a pivot but when you drill to details from the pivot the hyperlinks are gone.