Hi, I've a code which runs to refresh all pivots I've listed in an excel file with a specific data source, also listed in the cells of the excel file.
The code is able to execute, and refreshes the data, however, the data source range becomes corrupt after? It throws me error: "The PivotTable...