If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Table Formatting
Some of the formatting on my Pivot Tables remain after refreshing, some
formatting does not. I have "preserve formatting" checked, "Autoformat Table" unchecked. Excel 2002. Any help would be appreciated - I have had formatting problems with Pivot Tables for years!! |
#2
|
|||
|
|||
You may have to enable selection (From the Pivot toolbar, choose
PivotTableSelect, and click on Enable Selection) Before formatting cells, use the selection feature to select the cells. For example, move the pointer to the top of a column in the pivot table (just above the column's heading cell). When the black arrow appears (like the one that appears when the pointer is over a column button), click to select the column in the pivot table. Then apply the formatting. If that doesn't work, you could record a macro as you refresh and reformat the pivot table. Then, run that when you want to update. Phil vK wrote: Some of the formatting on my Pivot Tables remain after refreshing, some formatting does not. I have "preserve formatting" checked, "Autoformat Table" unchecked. Excel 2002. Any help would be appreciated - I have had formatting problems with Pivot Tables for years!! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
I am having trouble keeping numbers formatted in a Pivot Table | Liana H | General Discussion | 1 | April 22nd, 2005 07:43 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
pivot table formatting | dabrat | Worksheet Functions | 0 | August 20th, 2004 10:29 PM |