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? |
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