Excel unable to importa data from "mdb" file link
 

My excel uses database query from mdb (MS access) file. Now the file location
has changed.

So I am not able to "Refresh Data", inspite of creating a mdb shortcut to
correct folder.

For some reasons I can't copy the mdb file to new location, so looking for
workaround.

Is there any way to edit queries... (i am not able to do since it doesn't
recognize mdb file in first place)