Field drop-down arrows missing in pivot table....HELP!

[jwheelerk]

Hello all,

I was hoping to find some support on this issue. When ever I open an
existing pivot table or create a new pivot table I am not given the
option of the field drop-down arrows. I really need to have these
available for reporting and sorting purposes but can't figure out how
to activate or unhide them. I also have access to a windows machine and
the field drop-down arrows show up on pivot tables, when for the same
pivot table they will not populate on my MAC. The field drop-down
arrows would not populate from day one.
I'm wondering if there is an option 'un-checked" somewhere. Has anyone
ever seen this problem and/or can trouble shoot it?

Thanks for the help,
Jordan

 

[Peo Sjoblom]

I have windows at work but in windows excel the only way to hide them would
be under tools>options>view and if I have hide objects checked, so in a Mac
under preferences>view

 

[CyberTaz]

Hi Jordan-

Which version of Excel & which OS are you using on the Mac?

 

[jwheelerk]

I am using Excel: mac 2004 and mac OS X version 10.3.7...hope that
helps the trouble shooting!

 

[jwheelerk]

I had checked under preferences and it currently reads as 'show all'
Can you think of any other reason that this would be happening?
Thanks,
Jordan

 

[CyberTaz]

Afraid this one has me stumped (not unusual)!

One thing if you haven't alread done so... Try trashing the Excel
Preferences file (while the program is not running) and then launch
Excel and see if that makes a difference.

Good Luck, but I haven't given up |:>)