ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I set a default format of the drill down table? (https://www.excelbanter.com/excel-programming/426964-how-do-i-set-default-format-drill-down-table.html)

AudKen

How do I set a default format of the drill down table?
 
I have a pivot table sourced from Analysis Services with a drill down. When
I use the drill down, the detail report pops up in a new tab as desired.
However, the users are annoyed by the default coloring of blue rows. Is
there a way to set a default format for this? I know you can change it once
it's open, but our users don't want to do that, they want it formatted
differently every time and expect us to set a format default. I can't seem
to find a way to do this. Your help is appreciated!!!



All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com