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" <(E-Mail Removed)> wrote in message
news:A4299A0C-0E27-4FD6-AFA9-(E-Mail Removed)...
>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
|
