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