When you drill down on a PivotTable it brings up a separate sheet in a table format. I know you can click on "conver to range" and this works great for small amounts of data, but we are looking at a lot of data and the range conversion takes several minutes (almost 20-30 minutes).
Is there a way to drill down directly to a range instead of a table format?
Thanks!
Is there a way to drill down directly to a range instead of a table format?
Thanks!