Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Autoformats in Excel 2002
Dear All,
I am new to excel 2002 and would like to know if it is possible to modify or create autoformats for pivot tales so that I can effectively use the old ones from excel 97 in my vba code. Can anyone help? Gary Settery |
#2
|
|||
|
|||
You can't add to the AutoFormat list that appears when you're formatting
a pivot table, or modify the existing formats. However, you can use the following workaround: Select a cell in a regular table in the workbook (e.g. the pivot table data source) Choose FormatAutoFormat Select the formatting you want on the pivot table Click OK Select a cell in the pivot table Press the F4 key, to repeat the previous formatting You can then go back to the regular table, and set its AutoFormat to None Gary Settery wrote: Dear All, I am new to excel 2002 and would like to know if it is possible to modify or create autoformats for pivot tales so that I can effectively use the old ones from excel 97 in my vba code. Can anyone help? Gary Settery -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |