Where do excel 2003 add-in's live?
 

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.

Where do excel 2003 add-in's live?
 

Try using Edit, Links to change the source of the link.

--
Jim
"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.