ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to set default format of drill down report? (https://www.excelbanter.com/excel-discussion-misc-queries/227789-how-set-default-format-drill-down-report.html)

AudKen

How to set default format of drill down report?
 
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:19 AM.

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