Thanks for that, "Worksheet_Calculate" worked just how id hoped. My drill
down/up is the type where the pivot table expands rather that generates a new
sheet, so the calculate solution is the best to use for now. Thanks also to
Tom as the new sheet event will probably come in handy sooner or later.