I create a couple custom add-in's and saved them in a network folder under
the name ABCToolPak. After I created a few worksheets using the custom
functions associated with the ABCToolPak, I moved the add-ins to a different
network folder and renamed it XYZToolPak. I then uninstalled ABCToolPak and
installed XYZToolPak. I didn't change anything releating to the add-in's
themselves other than the name of the ToolPak and the network location.

Now when I try to use some of the spreadsheets I created using the
ABCToolPak, the formulas error out, because they try to look for the function
under the OLD add-in name and network location.

Are the add-in's stored in each worksheet? Is there something I am missing?
Thanks in advance

Todd,

Try to re-install the deleted ABCToolPak.xla through tools / add-ins. Excel should complain that it
can't find the file, and ask if you want to remove that file from the list of add-ins. Let Excel
remove the file from that list, and that may fix your problem....

HTH,
Bernie
MS Excel MVP


"ToddEZ" wrote in message
...
I create a couple custom add-in's and saved them in a network folder under
the name ABCToolPak. After I created a few worksheets using the custom
functions associated with the ABCToolPak, I moved the add-ins to a different
network folder and renamed it XYZToolPak. I then uninstalled ABCToolPak and
installed XYZToolPak. I didn't change anything releating to the add-in's
themselves other than the name of the ToolPak and the network location.

Now when I try to use some of the spreadsheets I created using the
ABCToolPak, the formulas error out, because they try to look for the function
under the OLD add-in name and network location.

Are the add-in's stored in each worksheet? Is there something I am missing?
Thanks in advance