JimBobBillyJean
New Member
- Joined
- Mar 8, 2009
- Messages
- 1
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![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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