I am encountering an issue when I create a pivot table in Excel 2007 and save
it as a .xls file. When coworkers are working in the file and click on the
field drop-down arrows, nothing happens. The arrows are visible, but they do
not open up to display the associated values.

Has anyone else experienced this? If yes, what did you do to correct? Is
there a Table option I'm missing?

Try double clicking a filter 'header' and I suspect you will get your
answer.

Excel 2007 pivots, being an upgraded area are not backward compatible in
earlier versions with regard to functionality...it seems

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"ExcelInstructor" wrote in
message ...
I am encountering an issue when I create a pivot table in Excel 2007 and
save
it as a .xls file. When coworkers are working in the file and click on
the
field drop-down arrows, nothing happens. The arrows are visible, but they
do
not open up to display the associated values.

Has anyone else experienced this? If yes, what did you do to correct? Is
there a Table option I'm missing?