MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot table in Excel 2000 and the enable drill down feature


Posted by Nona Sloven on August 02, 2001 6:41 AM

Hi:

I made a Pivot Table in Excel' 97 which I opened and then saved it in Excel 2000. Now my pivot table doesn't show me detail when I double clic a total as it did when it was in Excel' 97 although I have the "Enable drilldown" option in the Pivot Table options marked active (enabled). What's going on with this? I am doing anything wrong or Excel 2000 does not support the drill down feature for a table made in Excel' 97? Your help will be appreciated. Thanks.

Nona


Posted by Mark W. on August 04, 2001 6:29 AM

Well, let's see either Microsoft has reduced the
functionality of PivotTables when it released
Excel 2000 or you're doing something wrong. I
think I'd put my money on "you're doing something
wrong". Unfortunately, you haven't given me a
clue as to what that "something" is>