Pivot table changes from 97 to 2000

  • Thread starter Thread starter David Grimsled
  • Start date Start date
D

David Grimsled

In Excel 97 on a pivot table you could double click on a
data cell in the pivot table and a new worksheet would be
created that contains all the data that was being
summarized on the pivot table for that particular cell.

When I open a pivot table in 2000 that was created in 97,
this functionality seems not to exist.

Is there a way to enable this functionality in Excel 2000?

Any assistance will be greatly appreciated.

David Grimsled
 
If you haven't changed any of the settings in the table, it should allow
drilling down in Excel 2000, just as it does in Excel 97. To turn the
feature back on --

Select a cell in the pivot table
On the pivot toolbar, choose PivotTable>Table Options
Add a check mark to 'enable drilldown'
Click OK
 
Back
Top