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:R50000C38"

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

dmoney
Fri May 09 08:03:00 CDT 2008

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:R50000C38"
>
> The file from which the table should get it's data is called TestLines.xls

Kathl
Fri May 09 08:47:02 CDT 2008

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:R50000C38"
> >
> > The file from which the table should get it's data is called TestLines.xls

dmoney
Fri May 09 10:17:03 CDT 2008

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:R50000C38"
>
> The file from which the table should get it's data is called TestLines.xls

Kathl
Fri May 09 11:13:01 CDT 2008

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:R50000C38"
> >
> > The file from which the table should get it's data is called TestLines.xls