My add-in is not happy with a certain directory

  • Thread starter Thread starter Mike Krumel
  • Start date Start date
M

Mike Krumel

Greetings,
I have a sheet which is dependant on an add-in
to dynamically update itself in near-real-time(2 secs).
The problem is since last October the link to the add-in
won't keep saved in the right place, it always reverts
back to the old dir. Every day I have to edit the link to
the other directory and then my sheet is happy until I
close it. Then I have to go through the same routine
again. I have copied the add-in to the other directory so
they are identical files. Any suggestions?

C:\Program Files\FactorySuite\ActiveFactory\Office
Addins\Workbook <<Happy

C:\Program Files\Wonderware\ActiveFactory\Office
Addins\Workbook <<NOT Happy

Mike
 
Mike said:
Greetings,
I have a sheet which is dependant on an add-in
to dynamically update itself in near-real-time(2 secs).
The problem is since last October the link to the add-in
won't keep saved in the right place, it always reverts
back to the old dir. Every day I have to edit the link to
the other directory and then my sheet is happy until I
close it. Then I have to go through the same routine
again. I have copied the add-in to the other directory so
they are identical files. Any suggestions?

C:\Program Files\FactorySuite\ActiveFactory\Office
Addins\Workbook <<Happy

C:\Program Files\Wonderware\ActiveFactory\Office
Addins\Workbook <<NOT Happy

Mike
Click to expand...

The easiest thing to do is delete the add-in reference in the registry.
From Start/Run/type:regedit...[enter]. Navigate to this key
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Add-in Manager.
Find the key with the Add-in path and delete it. Close Regedit. Open
Excel and from Tools/Add-ins, browse to the new location for the add-in.

Q
 
Back
Top