Pivot Table issue in Excel 2007

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"ExcelInstructor" <ExcelInstructor@discussions.microsoft.com> wrote in
message news:D864D72E-DCB2-4454-B0C2-70766E25AC4B@microsoft.com...
>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?