Hi,
I have a few useful functions in an XLAM. This is referenced in my global Excel options and all workbooks I create are able to see and use the functions within it. I can also copy/move these workbooks to new locations within my C drive without issue. However, if I move them to a new location, the Add-in tries to link to a non-existant folder with the same path as the original add-in but an updated drive identifier at the front.
So the cell before I move it contains...
=CURVE_INTERPOLATE(<arrayA>,<ArrayB>,<Value>)
and the function works as expected.
If I copy this workbook to another location including other logical drives - even my Google Drive, everything works fine EXCEPT if I copy it to a OneDrive folder. If I do that, this is the cell contents after the copy:
=<OneDriveWebAddress>/Users/rsmith15/AppData/Roaming/Microsoft/AddIns/CURVE_INTERPOLATE(<arrayA>,<ArrayB>,<Value>)
Of course this folder doesn't exist and the formula gives a #Name? error.
The workbooks I might want to put in this location could contain tens if not hundreds of cells that access my add-in 'tools' so updating each cell is impractical.
Of course I can do a search/replace but I'm looking for a way to prevent the initial copy from doing this 'clever' update in the first place!
Any fixes please?
I have a few useful functions in an XLAM. This is referenced in my global Excel options and all workbooks I create are able to see and use the functions within it. I can also copy/move these workbooks to new locations within my C drive without issue. However, if I move them to a new location, the Add-in tries to link to a non-existant folder with the same path as the original add-in but an updated drive identifier at the front.
So the cell before I move it contains...
=CURVE_INTERPOLATE(<arrayA>,<ArrayB>,<Value>)
and the function works as expected.
If I copy this workbook to another location including other logical drives - even my Google Drive, everything works fine EXCEPT if I copy it to a OneDrive folder. If I do that, this is the cell contents after the copy:
=<OneDriveWebAddress>/Users/rsmith15/AppData/Roaming/Microsoft/AddIns/CURVE_INTERPOLATE(<arrayA>,<ArrayB>,<Value>)
Of course this folder doesn't exist and the formula gives a #Name? error.
The workbooks I might want to put in this location could contain tens if not hundreds of cells that access my add-in 'tools' so updating each cell is impractical.
Of course I can do a search/replace but I'm looking for a way to prevent the initial copy from doing this 'clever' update in the first place!
Any fixes please?
