Watch for two display tips in Excel Video 323. The first tip is helpful if you used to use Pivot Tables in versions of Excel prior to Excel 2007. Now that I’m familiar with the Pivot Table Field List, I don’t use the Classic Pivot Table layout any more, but it was very helpful when I converted from Excel 2003 to 2007.
The second tip is a way to sort the fields in your Pivot Table Field List alphabetically instead of in the same order as the Pivot Table data source. Especially if you don’t have control over how you get your data from your PM, EMR, or other software system, you may want to put the Pivot Table fields in an order that makes sense to you.
Stay tuned. I have a way to fix a strange feature of Pivot Tables that may look like a bug when you first see it.
