I have a problem. We have a complex sheet, which will be used by a number of people who get a local copy.
We want to use a VLookup function to retrieve default numbers from a Excel Sheet located on the network.
The problem is that when we type in location of this central file and we open the file part of the path is substituted with the startup directory of the user. Does anyone know how to prevent this?
Thnx in advance