I inherit a XLS file that has multiple pivottables, and no underlying data. I
have to refresh each of these tables one at a time. (yuck) is there an option
I am missing? What VBA could I use to make this easier for me?