• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to format generated drilldown sheet from pivot table?

J

Jason3456789

New Member
Hi all,

I could really use some help with this...

I have a simple pivot table that is drawn off a relatively simple data sheet. This file is to be distributed to middle and upper management which means... the user isn't very handy with excel.

Long story short, when they click on the value in the pivot table to drill down to the source data, of course excel generates a new sheet to display that source data. Unfortunately though, excel uses the default blue-banded display and I don't like how that new page is formatted.

How do I ensure any and all newly generated sheets retain the source data formatting?

Due to the number of values in the pivot and file size limitations (I'm saving it to sharepoint and need to keep the file size as small as possible), I'm not able to go thru and click on all values, use format painter, then hide and save each sheet.

I would also like to try to avoid using a macro or vba code - if at all possible.

Please advise.

Jason
 
This is similar to using the format painter. This doesn't do what I want it to.

Basically, I've spent a lot of time formatting the source data (column width, font size, font color for different rows indicating certain rows are in "trouble"). I need to allow the user to click on a pivot table value and the sheet that is displayed needs to display this data with the source formatting.

Is there a way to do this?

Thank you for your help - and your time!

John


prasaddn said:
Hi,

You need to change the default table settings.

You can open any existing table and make necessary changes to table and set that as your default table settings. Once this is done, any drilldown will pick up the same.

Refer to this link:
http://www.pivot-table.com/2011/06/14/pivot-table-drilldown-formatting/

Regards,
Prasad DN
Click to expand...
 
You need to bypass default table design with that of your choice. try this:

step1:
Home ribbon >> format as table >> New Table style .. New Table Quick style pops up.
step2:
customize the rows/columns in the by selecting appropriate table elements and formatting.
step 3 and important:
check the set as default table quick style for this document
step 4
click ok.

thats it, now all drill down comes in the way have set!

Tested and working ;)

Regards,
Prasad DN
 
You must log in or register to reply here.
Back
Top