I have a pivot table in spreadsheet A.
I have some formulas in another spreadsheet B.
The formulas look up data in the pivot table in A and use that data in B to return and answer.
Is there a way to refresh the pivot table in A from B without having to open A and refresh the table?
Hope that makes sense.