Spawn pivottable sheet

  • Thread starter Juan Manuel Porras Gálvez
  • Start date
J

Juan Manuel Porras Gálvez

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.
 
D

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.
 
J

Juan Manuel Porras Gálvez

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ó:
 
D

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
 
J

Juan Manuel Porras Gálvez

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ó:
 
Top