tshaffer03
New Member
- Joined
- Jul 7, 2003
- Messages
- 12
I have a pivot table with a filter. The report is formatted differently than the default formatting (i.e. column width made smaller, color shading for columns, light grey dotted lines for cell borders, wrapping text). The option "Preserve Cell Formatting on Update" and "Classic Pivot Table Layout" is used.
When I change the value of the filter, the Pivot Table format does not change.
Then, when selecting "Show Report Filter Pages...:", the worksheets are created correctly for each person but the formatting is not totally preserved (cell width is not preserved, the color coding, wrapping, and cell borders are preserved). I would have to re-format all of the tabs every time I run this daily report.
How do I get the worksheets generated from the "Show Report Filter Pages" option to use the same column width as the original? I'm stumped!
MSExcel Office 2007
When I change the value of the filter, the Pivot Table format does not change.
Then, when selecting "Show Report Filter Pages...:", the worksheets are created correctly for each person but the formatting is not totally preserved (cell width is not preserved, the color coding, wrapping, and cell borders are preserved). I would have to re-format all of the tabs every time I run this daily report.
How do I get the worksheets generated from the "Show Report Filter Pages" option to use the same column width as the original? I'm stumped!
MSExcel Office 2007