Pivot table "drill down to data"

Pivot table "drill down to data"

Post by koskey » Thu, 22 Feb 2007 05:56:21


On my pivot table users will drill down to supporting detail based on
the code in the first column - is there any way to make the underlying
detail sheet appear as a separate workbook?

I want to keep the original data/pivot table clean from extra sheets
created by drilling down.

Thanks for any insights. J. Koskey