Excel allows you to apply conditional formatting in a PivotTable, but the outcome of that application may not be satisfactory when the table is refreshed. This tip discusses ways you can change the default SUM function to a different function.Ĭonditional formatting is very powerful, and you can use it to dynamically adjust how your data looks. When you create a PivotTable, Excel automatically sums the data that you place into the Data Items area of the table. The only way around the problem is to not use such PivotTables in the earlier version of the program.Ĭhanging the Default PivotTable Functions If you create a PivotTable in Excel 2007, you may have problems editing or updating that PivotTable in Excel 2003. Here's some ideas on how to speed things up.Ĭan't Update Excel 2007 PivotTables in Excel 2003 The reason for this may be due to the way in which you directed the PivotTable to analyze your data. Create a complex PivotTable and you may find that your system slows to a crawl.
0 Comments
Leave a Reply. |