How to make external data path relative

StuLux

Well-known Member
Joined
Sep 14, 2005
Messages
679
Office Version
  1. 365
Platform
  1. Windows
I have tried several ways to make my external data path relative rather than absolute without success. Does anybody know a way to do this i.e. I have used the Data, Import External Data route but when I try to refrsh the data on another users PC (where he has access to the same drive but it is mapped to another drive letter) the refresh will not work.

I'm sure I'm misssing something very simple but it is driving me mad and I'm going on holiday in 1 hours time and would really like to fix this before I go!
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
don't use the mapped drive letter. use the network path.

\\servername\folder\filename.xls
 
Upvote 0
I knew it was simple! I relaised I needed to replace the drive letter but couldn't work out where. You have just prompted me to remember how I did it before, many thanks.
 
Upvote 0
Although I can make the path absolute in this way when I want to edit the query I can't do this in MS Query. I want to be able to filter the data I retrieve using the value in an Excel cell. I don't really want to use VBA for this if I can help it because I don't want to amend any existing queries in the database as it is not mine.

Is there any way to use MS query to import external data with the path to the external data saved as a relative path?
 
Upvote 0
Did you find an answer to your problem? I have exactly the same problem as I want to use database/query configuration on different computers not connected in a network.
I use Excel 2003.
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top