Hey all..
I really hope someone can help me...
I'm trying to create a pivot table in a blank workbook.
The table should get it's source data from an excel-file on a different (network) drive.
I've tried something like this:
'p:\cars & bikes\[overview 2006.xls]vehicles'!$a$1:$m$2500
With 'p:\cars & bikes\' being the path to the file, [overview 2006.xls] being the file with the source data, 'vehicles' being the sheet-name with the data and a1:M2500 being the range....
Somehow this matrix doesn't work.
The pivot should be in a file with only the PT, taking data from the source upon 'update'. The PT should be on the users c-drive..
Anyone with proper knowledge?
Thanks in advance
I really hope someone can help me...
I'm trying to create a pivot table in a blank workbook.
The table should get it's source data from an excel-file on a different (network) drive.
I've tried something like this:
'p:\cars & bikes\[overview 2006.xls]vehicles'!$a$1:$m$2500
With 'p:\cars & bikes\' being the path to the file, [overview 2006.xls] being the file with the source data, 'vehicles' being the sheet-name with the data and a1:M2500 being the range....
Somehow this matrix doesn't work.
The pivot should be in a file with only the PT, taking data from the source upon 'update'. The PT should be on the users c-drive..
Anyone with proper knowledge?
Thanks in advance