updating pivot table data via external xls file which is replaced
 

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:R50000C 38"

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

updating pivot table data via external xls file which is replaced
 

If you look at your code u will see a U: at the front of your path. This is
to a mapped drive. In order for it to work, u need to put the full path in
--in place of u: you need to put the actual server name instead

\\server\directory\filename

HTH

Devin

"Kathl" wrote:

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:R50000C 38"

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

updating pivot table data via external xls file which is repla
 

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

"dmoney" wrote:

If you look at your code u will see a U: at the front of your path. This is
to a mapped drive. In order for it to work, u need to put the full path in
--in place of u: you need to put the actual server name instead

\\server\directory\filename

HTH

Devin

"Kathl" wrote:

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:R50000C 38"

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

updating pivot table data via external xls file which is replaced
 

no sure i understand the problem but you will need to open the file to update
it

Workbooks.Open _
Filename:="C:\tst.xls"

"Kathl" wrote:

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:R50000C 38"

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

updating pivot table data via external xls file which is repla
 

isn't it somehow possible to query the file without opening it?

"dmoney" wrote:

no sure i understand the problem but you will need to open the file to update
it

Workbooks.Open _
Filename:="C:\tst.xls"

"Kathl" wrote:

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:R50000C 38"

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