Update PivotTable

[lance.schaeffer]

I have a series of pivottables on different tabs.

I have the first one updated from an MS access database. The rest of
the pivottables are all built on the data from the first pivot table.

I have a macro set up to do the requery to the database which works
fine - however, when I try to get code to refresh the rest of the
pivotTables, which are built on the dataset from the first, i am
running into all sorts of problems. Any idea on how I should be writing
a macro to get the data to refresh properly based on the first
pivotTable?

 

[lance.schaeffer]

I forgot to add..

The code I am TRYING to use to get the pivotTable to relink is as
follows:

ActiveSheet.PivotTableWizard SourceType:=xlPivotTable, SourceData:= _
"LaborData"

 

[lance.schaeffer]

I forgot to add..

The code I am TRYING to use to get the pivotTable to relink is as
follows:

ActiveSheet.PivotTableWizard SourceType:=xlPivotTable, SourceData:= _
"LaborData"

 

[Debra Dalgleish]

If all the pivot tables use the same source data, and you refresh one,
that should refresh the data for the others. What problems are you having?

 

[Debra Dalgleish]

If all the pivot tables use the same source data, and you refresh one,
that should refresh the data for the others. What problems are you having?

 

[lance.schaeffer]

Well,

This is what I have been told, however, it does not seem to be working
this way. I set the second pivot table equal to the first. Then I
update the first pivot table, and the second one will not refresh. I
will look into a work-around since I'm guessing something isn't working
due to a setting somewhere that I'll never find.

 

[lance.schaeffer]

Well,

This is what I have been told, however, it does not seem to be working
this way. I set the second pivot table equal to the first. Then I
update the first pivot table, and the second one will not refresh. I
will look into a work-around since I'm guessing something isn't working
due to a setting somewhere that I'll never find.

 

[Debra Dalgleish]

Ron Coderre has a pivot table add-in that lets you view and edit the
connection string and command text, so you can change the source, in
Excel 2002 or Excel 2003:

http://www.contextures.com/xlPivotPlay01.html

Maybe that would help with the updates.

Well,

This is what I have been told, however, it does not seem to be working
this way. I set the second pivot table equal to the first. Then I
update the first pivot table, and the second one will not refresh. I
will look into a work-around since I'm guessing something isn't working
due to a setting somewhere that I'll never find.

 

[Debra Dalgleish]

Ron Coderre has a pivot table add-in that lets you view and edit the
connection string and command text, so you can change the source, in
Excel 2002 or Excel 2003:

http://www.contextures.com/xlPivotPlay01.html

Maybe that would help with the updates.

Well,

This is what I have been told, however, it does not seem to be working
this way. I set the second pivot table equal to the first. Then I
update the first pivot table, and the second one will not refresh. I
will look into a work-around since I'm guessing something isn't working
due to a setting somewhere that I'll never find.