I am using Excel 2003 and my team frequently uses the "drill-down" function
in a pivot table but the sort / formatting is not retained when the tab with
the drill-down data is opened. For example, if a row header is "State", and
in the data section, AL has 100 offices; I can dbl click on the number 100
and a new tab will open with the detail for each of those 100 offices.
However, the output is very messy - 6 decimal points, no sorting, etc. Do you
know how i can fix it?