Hi,

I don't think you can refresh a closed pivot table even with VBA. You might
open an instance of the file that you can't see and then refresh it but its
still in memory to the best of my knowledge.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"gildengorin" wrote:

I believe this takes me into the VBA realm and that is uncharted territory
for me. Here we go: I have 10 pivot tables in workbook A on worksheet 1. I
need these pivot tables to refresh whenever cell R1C1 in workbook B on
worksheet 2 changes. I need this to be done without having to have workbook A
open (it is very large). Please advise.

Thanks!