(This process can be a bit intimidating, but it can be done.)Īnother idea is to create a workbook with the PivotTable formatted as desired and then save that workbook as read-only. One thing you might try is to develop a macro that does the formatting for you-start by recording the process of formatting your PivotTable, and then adjust the macro so that it is more global and can apply to almost any PivotTable you create. Unfortunately, there is no way to create a default format for your PivotTables that we've been able to discover. ![]() He wonders about the easiest way to set default formatting for PivotTables so that he can avoid going through the repetitive process of formatting each new PivotTable. Being able to set a default such as this would save James a huge amount of time. ![]() He would like all PivotTables to start in the classic format with no subtotals and repeated row items with all values in accounting format with no currency sign and no characters after the decimal. ![]() James is frustrated when it comes to formatting PivotTables.
0 Comments
Leave a Reply. |