yes, that would make sense from the question I asked. There was
actually another part that I left out. When you drill down into a pivot
table and a new sheet is created, I was putting this code in the
newsheet event because it loses the hyperlinks otherwise. Thanks for
you idea too..