Pivot table drill down

[serickson]

When I create a pivot table, I can double click on a value in the table and Excel creates a new sheet in the workbook with the details behind this data point.

One of my co-workers cannot do this. Is there a setup item that will enable this feature?

Thanks.

 

[Mark W.]

On 2002-04-10 13:10, serickson wrote:
When I create a pivot table, I can double click on a value in the table and Excel creates a new sheet in the workbook with the details behind this data point.

One of my co-workers cannot do this. Is there a setup item that will enable this feature?

Thanks.

Make sure that both "Enable drilldown" and "Save data with table layout" PivotTable options are checked. Right-click on the PivotTable and choose Options... from the popup menu.

 

[serickson]

Yes, both boxes are checked and still no drill down.

Any other ideas?

Thanks.

 

[Mark W.]

On 2002-04-10 15:17, serickson wrote:
Yes, both boxes are checked and still no drill down.

Any other ideas?

Thanks.

Sorry, I must ask... where exactly are they clicking? Is the worksheet protected?
This message was edited by Mark W. on 2002-04-10 15:20

 

[serickson]

That's a fair question.

The workbook/sheet is not protected. She creates them all the time as the rest of us do. All of us are able to drill down by clicking on an amount in the pivot table. A new sheet is created with all of the details.

I've tried it on her machine without success. (I told her to upgrade to 2000) But if in the meantime we can get it to work for her, that would be great.

Thanks for your time.

 

[Chris Davison]

okay, so this problem is machine-specific ?

 

[serickson]

It seems to be happening only on one machine.