Hyperlink lost in drilldown

  • Thread starter Thread starter erikd
  • Start date Start date
E

erikd

I set up a spreadsheet with a list of documents on our server so that
we could easily refer to them during meetings. During our last meeting
we tried to use a pivot table and drilldown to one of the totals, but
the cell in the new worksheet lost the hyperlink capability.

Does anyone know why? Or have a guess? The drilldown using the pivot
table is a great feature and will make the meeting more productive, as
long as we can keep the hyperlink capability in the new worksheets.

Erik
 
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.
 
I'm using it with xl2000, but it's good to know that I didn't miss
something obvious. I never thought about what else it's losing on a
drilldown, I never even thought about formulas. But then again, I can
think of a couple of ways this could be an advantage. For instance, it
may be quicker than a "Paste special" to remove formatting, formulas
and hyperlinks!

But you're right, I may be able to use the filter to do what I need. I
tend not to use the filter though since I got burned when it didn't
show all the choices. Almost as if the filter has a memory or number
limit.

We tend to trust our software and when something goes wrong, forget
Occams Razor. I was reviewing a worksheet with my manager and he said
I must have done something wrong since an expected result wan't in the
list when he searched for it using the filter. But the value was found
later by using Ctrl-F.

Erik
 
The autofilter dropdown will display a maximum of 1000 unique entries.

But you can use the Custom filter and type what you want and it'll work ok.
 
Back
Top