Refresh pivot table in workbook A when changing a cell in workbook

G

gildengorin

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!
 
S

Shane Devenshire

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.
 
G

gildengorin

I moved the 10 pivot tables in workbook A, worksheet 1 to workbook B.
Essentially everything is in the same workbook. How do I use VBA to refresh
all pivot tables in the workbook when cell A1 is changed? I assume this is
straight-forward and I am just missing something. Help greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Refresh 5
Workbook pivot table design function 6
PivotTable auto-refresh with external data 4
Auto insert of a pivot table? 1
Help Required: Pulling data from a workbook into a worksheet. 1
refresh multiple pivot tables in workbook 2
How do I refresh Pivot Table from an external source ? 3
Create refresh button in worksheet to refresh Pivot Table Data 1

Top