Thank you AB. I think i'd better stick to my current method.
Hide the colums where the pivot table resides on and move everything
somewhere else.
And thank you Don for your kind offer.
Rgds