updating pivot table data via external xls file which is replaced

K

Kathl

hi,

the problem with my code for updating the table is that it works on my
computer but if i try it on another one the pivot table itself isn't updated
but a new worksheet created with an empty pivot in it

ActiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:= _
"U:\xyz\xyz_Shared\test\TestLines.xls!R4C1:R50000C38"

The file from which the table should get it's data is called TestLines.xls
 
K

Kathl

thx; now it seems to be trying to access the file but it tells me that it
cannot open it. any further suggestions?
 

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

Macro to update pivot table data range 3
Excel Error while updating an external data source into a pivot table! 0
Pivot table Macro help!!! 3
Please help! Cannot open pivotTable source file.... 2
Playing back a Pivot Table macros 2
macro creating new pivot table 2
Change SourceData in Excel PivotTable via VBA 1
Pivot macro problem 2

Top