Reling Pivot sourcedata to network drive
 

Hi,

I want to update the sourcedata prop to point to a network path an
file.

for example:
Taking variable VarMonth and using as follows

ActiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:
"'[" & VarMonth & ".xls]Data'!$A:$Z"

This works fine if I am using a file in the same directory. However i
you have a file on your desktop. The relink doesn't work.

Any ideas/solutions/workarounds gratefully received.
cheers,
Matt

--
Message posted from http://www.ExcelForum.com