Thanks for your quick reply.
OK, I'm set on how the table changes. But where do I place this code? I tried pasting it into a module in the Pivot Table worksheet, and then adding some data, but it didn't change, so I must be doing something wrong...
Lori