Spawn pivottable sheet

[Guest]

Hello all!!,

how could spawn data on double-click on a new sheet over a pivottable in
Excel 2000?.

In Excel 2003 it's possible, but are there any options in Excel 2000?

Thanks very much.

 

[Debra Dalgleish]

If you double-click on a pivot table cell in Excel 2000, it should
create a new sheet, with the source data for that cell.

 

[Guest]

Ok, but I think in Excel 2000 there is no possibility to do that.
Double-clicking on a pivot table cell, don´t create a new sheet in Excel 2000.

Is it possible there is an option to do that in Excel 2000 and, by default,
it's disable?.

Thanks very much.

"Debra Dalgleish" escribió:

 

[Debra Dalgleish]

Right-click on a cell in the pivot table, and choose Table Options
Under Data options, add a check mark to 'Enable drilldown'
Click OK

 

[Guest]

hmmmm....

In Excel 97 and 2003, there's no problem doing that; but, the problem is in
Excel 2000 where It looks like that "Save Data with table ..." it's necessary
same as "Enable Drilldown" to Show/Hide details.

Do you think that there is a problem with the installation, the ODBC source,
....?.

Any ideas?.


"Debra Dalgleish" escribió: