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

I may be mistaken, but I believe you can just right-click one of the values
and select Number button. Then you can pick your format from there and it
should update all like values.

right-click on the row field for your desired category and pick field
settings to remove subtotals...

"ChuckW" wrote:

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

Sean,

Thanks for your help. I can right click one of the cells and select format
and choose a format such as currency but it only formats that one cell. I
used to be able to click inside the pivot table on the far left. The cursor
would turn to an arrow. When I did this, it would select all values and I
could click currency. Also, I could hide all of the totals. I could do a
calculated field and then make the formatting percentage. I have lost this
functionality. I checked the formatting for pivot table but could not locate
this functionality.


--
Chuck W


"Sean Timmons" wrote:

I may be mistaken, but I believe you can just right-click one of the values
and select Number button. Then you can pick your format from there and it
should update all like values.

right-click on the row field for your desired category and pick field
settings to remove subtotals...

"ChuckW" wrote:

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

In that case, I am as confused as you are...

Does this occur with all files you have? Want to make sure it's not
something related to protection, sahring, macro, etc.

"ChuckW" wrote:

Sean,

Thanks for your help. I can right click one of the cells and select format
and choose a format such as currency but it only formats that one cell. I
used to be able to click inside the pivot table on the far left. The cursor
would turn to an arrow. When I did this, it would select all values and I
could click currency. Also, I could hide all of the totals. I could do a
calculated field and then make the formatting percentage. I have lost this
functionality. I checked the formatting for pivot table but could not locate
this functionality.


--
Chuck W


"Sean Timmons" wrote:

I may be mistaken, but I believe you can just right-click one of the values
and select Number button. Then you can pick your format from there and it
should update all like values.

right-click on the row field for your desired category and pick field
settings to remove subtotals...

"ChuckW" wrote:

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

I am not sure about 2000 but in my 2007 Excel I choose Pivot Tables, Select,
and then make sure Enable Selection is pressed. That will give you the thick
black arrow you are looking for that when you hover your mouse at the
beginning of a row, which then allows you to select all rows of a field at
once.



"ChuckW" wrote:

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