I have a Pivot table that was created in Excel 2000. I now have Excel 2003
and I've noticed some alignment errors when there are zero values displayed.
Essentially, you have nested values with a subtotal running above (see
example)

New York 500
1 100
2 100
3 100
4 100
5 100

500 represents the total of subcategories 1-5. When there are all zero
values, the result in Excel 2003 is shown below:

New York 1 0
2 0
3 0
4 0
5 0

Basically, every time there are zero values, the rows are off by one, and
the effect is cumulative so additional formulas pointing to those locations
have to be realigned. Any ideas?