Hi,
I have Excel 2000. Once I created a pivot table, I used to be able to
format various fields as currency or percentages and hide totals. I would
hover my mouse at the beginning of a row and click. It would highlight all
values in a category. I would then select currency and it would highlight
all currency values in the category. For some reason, I lost this
functionality. The output in a pivot table can no longer be highlighted. I
don't remember changing anything though. Can someone help?

Thanks,
--
Chuck W