Add-In Location Question

[twt4757]

I have a custom Excel add-in that contains functions used by multiple users to run spreadsheets. This add-in is located on the C drive in the same directory on each users machine. This works fine when the users open spreadsheets that are located on their local C drive, but problems arise when spreadsheets are opened from shared network drives and Excel cannot find the location of the add-in.

Example: If a spreadsheet is opened from the P drive, Excel looks for the add-in on the P drive. When it can't find it, it put's an invalid path name in the formula bar with the incorrect drive letter (P instead of C). This can be fixed either by re-mapping the add-in to the C drive or by doing a find/replace to basically remove this file path from the formula bar.

My question is if there is a way to automate this so that Excel looks for this add-in on the C drive, regardless of which shared drive it might be opened from?

Any advice or suggestions would be greatly appreciated.

Thanks!

 

[RoryA]

Assuming you refer to UDFs in cells when you say functions, that should not happen because the path to the add-in is actually stored (hidden) as part of the function call. However, if you have several users using the same add-in on a network, you may want to use a central location for the add-in itself (stored as read-only) and when the users install it, they should choose not to copy it locally. See Ken's article here: Excelguru Help Site - Deploying Add-ins in a Network Environment

 

[twt4757]

Assuming you refer to UDFs in cells when you say functions, that should not happen because the path to the add-in is actually stored (hidden) as part of the function call. However, if you have several users using the same add-in on a network, you may want to use a central location for the add-in itself (stored as read-only) and when the users install it, they should choose not to copy it locally. See Ken's article here: Excelguru Help Site - Deploying Add-ins in a Network Environment

The add-in will not be on the network drives; only the users local C drive. Instead of having Excel look for the add-in on the P or F drive when a spreadsheet is opened from there, I'd like for it to always default back to the C drive and look for the add-in there.

 

[RoryA]

I think perhaps you misread my post. I said that:
1. The situation you describe should not occur
2. You should think about storing the add-on on the network. I am aware that is not yourcurrent setup.

 

[Andrew Poulsom]

Here is an article that discusses the behaviour that you are seeing:

Fix Links to UDFs