M
mahk
I have a workbook that refers to functions in an add-in module. The workbook
was built on a machine running 2000, so the add-in was installed in
C:\Program Files\ProcessSuite\ActiveFactory\Office Addins\Workbook\. I am
running on XP, and I have installed the Add-In. My add-in is located at
c:\documents and settings\<my name>\Application Data\Microsoft\Addins
When I open the workbook, all of the formulas have the full path reference
to the .XLA file, and every formula gives a #Name? error. If I remove the
path name from the formulas, the workbook runs correctly. Good so far.
When I save, close and reopen the workbook, the path reference is back in
every formula, and the #NAME? errors are back.
I have tried making the changes and then doing a Save As to a different
file. I have tried copying cells to a new blank workbook. Nothing works.
How can I remove references to the path where the Add-In was initially
installed?
was built on a machine running 2000, so the add-in was installed in
C:\Program Files\ProcessSuite\ActiveFactory\Office Addins\Workbook\. I am
running on XP, and I have installed the Add-In. My add-in is located at
c:\documents and settings\<my name>\Application Data\Microsoft\Addins
When I open the workbook, all of the formulas have the full path reference
to the .XLA file, and every formula gives a #Name? error. If I remove the
path name from the formulas, the workbook runs correctly. Good so far.
When I save, close and reopen the workbook, the path reference is back in
every formula, and the #NAME? errors are back.
I have tried making the changes and then doing a Save As to a different
file. I have tried copying cells to a new blank workbook. Nothing works.
How can I remove references to the path where the Add-In was initially
installed?