Drilling into pivot table loses hyperlinks

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

I have my data on Sheet1 and in Column A the entry IDs are hyperlinks.
When I create a pivot table on another sheet referencing to Sheet1
and then drill into the data, it brings up the correct data from
Sheet1, but the hyperlinks aren't there, just the entry IDs.

Is there some way to get the hyperlinks to show up when you drill into
the the pivot table?

Thanks,
Christine
 
I don't think so.

I put some hyperlinks in column A (some via insert|Hyperlink and some via
=hyperlink()).

When I created the pivottable, the links for both kinds were gone.

When I drilled down, they were still gone.

It sure looks like xl2002 (the version I tested) doesn't bring the hyperlink
with it in pivottables.

But it doesn't bring formulas, too. So you lose a lot of stuff.

Maybe you can apply Data|Filter|autofilter to the original range and utilize
that instead of drilling down.
 
Back
Top