Help - Many of us in our group live on and distribute pivot tables in our monthly reporting. Our favorite view was the old "list 2" that gave alternating green and white bars and bolded subtotals. This is gone in office 2000 and only exists as a data format not a pivot format. The only way I have figured out how to get it is to open and old pivot and swap the data tab and refresh. This is a pain. Any other ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Autoformat of Pivot table has changed in Office 200
- Thread starter davekd
- Start date
Excel Facts
Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Similar threads
- Question
- Replies
- 0
- Views
- 449
- Question
- Replies
- 1
- Views
- 901
- Replies
- 0
- Views
- 423
- Replies
- 0
- Views
- 1K
- Question
- Replies
- 0
- Views
- 3K
