Existing Source refresh

[gmazza76]

Good afternoon,

Is there anyway in PowerPivot connections to remove the C: or drive id from the existing connection as we all use the same shared drive but have it named differently depending on which drives are being used. It could be aligned to myself as below as a "Y:"

current
Y:\Folder1\folder2\folder3\filetouse.txt

with correct routing for a shared drive it should be something like the below.
\\SourceF1\SourceF2\Folder1\folder2\folder3\filetouse.txt

But I cannot get the file to be found as the error comes up as "The file you selected does not exist. Select an existing file."

Has anyone had this error before?

thanks in advance

 

[Alex Blakenburg]

Are you sure you have the full file specification correct ?
The way I normally get the full specification is to

• open either a blank Outlook email or a blank Word document.
• In explorer navigate to the file.
• right click on the file and drag it to Outlook or Word
• When you get it there select "Create Hyperlink Here"
• You should now see the full file specification.
  (even though you used the Drive mapping to get to the file and its the drive mapping that shows in the Explorer address box)