ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table issue in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/96815-pivot-table-issue-excel-2007-a.html)

ExcelInstructor

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?

Nick Hodge

Pivot Table issue in Excel 2007
 
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?





All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com