Pivot table changes from 97 to 2000

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
 
D

Debra Dalgleish

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
 
Top