Missing NUMBERS button in PivotTable Field Settings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles - 22 Nov 2006 18:56 GMT

I'm trying to format a field in a PivotTable row. When I right-click and
choose Field Settings, I don't see the NUMBERS button (usually located
underneath the LAYOUT button). Why is this happening? I have Excel 2003,
SP2.

Reply to this Message

Prasadkakarla - 23 Nov 2006 10:00 GMT

see charles
In excel Pivot table is very important option
i understood u r problem may be my answer is useful for u
if u r not fine the numbers button then u do one thing just click the qty
or total field of the pivot table and use short cut key ctrl +1 may be this
is useful for u i will check another way and i will send u antoher process ok
Prasad.Kakarla

> I'm trying to format a field in a PivotTable row. When I right-click and
> choose Field Settings, I don't see the NUMBERS button (usually located
> underneath the LAYOUT button). Why is this happening? I have Excel 2003,
> SP2.

Reply to this Message

Charles - 23 Nov 2006 10:09 GMT

Thank you - I'll give it a try on Monday, if not sooner!

> see charles
> In excel Pivot table is very important option
[quoted text clipped - 8 lines]
> > underneath the LAYOUT button). Why is this happening? I have Excel 2003,
> > SP2.

Reply to this Message

Charles - 27 Nov 2006 20:09 GMT

I just tested it. I can change the formatting however, whenever I update the
Pivot Table, it all reverts back to the original formatting.

> see charles
> In excel Pivot table is very important option
[quoted text clipped - 8 lines]
> > underneath the LAYOUT button). Why is this happening? I have Excel 2003,
> > SP2.

Reply to this Message