How do you restore the default color (black) for PivotTables created through the Wizard? Current PivotTables default to red borders instead of black. The borders may be manually changed to another color but return to red when the data is refreshed. Please help!
-
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.
Restore Default Excel 2003 PivotTable Colors
- Thread starter A1S
- Start date
After many hours of troubleshooting and frustration, I discovered that it is related to the color pallette. You are able to customize your color pallette through Format>Options>Color. By changing the top-left color to anything except black, you then change the default border colors for PivotTables. Don't know why this happens, but don't change that top-left color unless you want to run into this issue!
Upvote
0
Similar threads
- Question
