Sorry for the late reply. Setting the calculation to manual does not stop slicers from automatically manipulating the pivot tables. That was the only thing I tested, and found it didn't work.
In reality, the time it takes for one slicer to update all the pivot tables (8-10 seconds) is manageable. just don't want to have wait after each slicer is changed.
Any other ideas?
Bookmarks