this code is preventing it from working..I get "failed to create pivotache" or something along those lines.
set cachePT = activeworkbook.pivotcaches.create(xldatabase, range("source_pivot"))
i'm trying to create the pivot in the "summary" sheet while "source pivot" is based on the "STR"...