That may be hard.

The data that feeds the table comes from different sheets and the whole book is now alittle over 20 meg.

I'd have to simulate the data in one sheet then redo the pivot table.
May take alittle bit to do, but I am willing if I can figure it out.

thanks for offering to help....let me see what i can do