I have a large spreadsheet with many pivot table reports. I want a macro
that will update all of them with one click of the mouse.

Any help?

Thanks.

Kevin