Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh pivot table in workbook A when changing a cell in workbook
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh pivot table in workbook A when changing a cell in workbook
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh pivot table in workbook A when changing a cell in work
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. "Shane Devenshire" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pvt Table Refresh in Share Workbook Mode | Excel Discussion (Misc queries) | |||
XL 2007: Pivot Refresh slow when data resides in another workbook | Excel Discussion (Misc queries) | |||
How to copy pivot table workbook to new workbook? | New Users to Excel | |||
Add a button to refresh a pivot in another tab of the same workbook | Excel Discussion (Misc queries) | |||
Refresh all pivot tables in a workbook | Excel Discussion (Misc queries) |