Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 857
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pvt Table Refresh in Share Workbook Mode Vick Excel Discussion (Misc queries) 1 July 26th 07 10:06 PM
XL 2007: Pivot Refresh slow when data resides in another workbook funnybroad Excel Discussion (Misc queries) 1 May 31st 07 07:31 AM
How to copy pivot table workbook to new workbook? Wendy New Users to Excel 0 May 8th 06 11:57 PM
Add a button to refresh a pivot in another tab of the same workbook DMithias Excel Discussion (Misc queries) 2 February 10th 06 05:31 AM
Refresh all pivot tables in a workbook nc Excel Discussion (Misc queries) 3 June 22nd 05 06:37 PM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"