I have built an excel (in 2010) Table with some attached pivot tables within the same workbook. A team of 3 staff update the table on a daily basis. Whenever I meet them which is once a week they have the same complaint...the pivot table sheets are disabled. What could be the issue? They use excel 2007.
Everything seems to be OK on my computer. The Pivot Tables are active and the field list is displayed but in their system you only see the last pivot snapshot. When you click anywhere the pivot table, the design tool is not activated nor is the pivot field list.