Add-ins and User Defined Functions

[Vicki]

I have an ErlandC Add in I am using on my system. I have
a workbook that uses the user defined functions in the
worksheet. When I send the file via e-mail to anyone else
to use, once they save the file - they get a #NAME? error
anywhere the user defined functions have been used. These
people also have add ins loaded on their PCs. If I go
into each formula and redo the formula on their PCs, it
will work.

How can I make this work without redoing each formula each
time?
Thanks
Vicki

 

[hgrove]

Vicki wrote...

I have an ErlandC Add in I am using on my system. I have a
workbook that uses the user defined functions in the
worksheet. When I send the file via e-mail to anyone else to
use, once they save the file - they get a #NAME? error
anywhere the user defined functions have been used. These
people also have add ins loaded on their PCs. If I go into each
formula and redo the formula on their PCs, it will work.

How can I make this work without redoing each formula each
time?

All I can think of is that either you and your users have differen
versions of the ErlandC add-in or Excel is loading add-ins in differen
order on your system and the other users' systems. In either case, wha
you see in the formula bar or cell in Edit mode isn't what Exce
actually stores in memory. Excel uses numeric pointers to add-i
functions, and it stores the numeric pointers in the interpretted
binary representation of formulas in memory. It seems the numeri
pointers differ on your system and those of the other users. If so
re-entry of formulas is unavoidable, but there's an easy way to do it.

Select all cells.

Run Edit > Replace, find = and replace with = .

That's all. Replacing = with itself will effectively re-enter al
formulas, and that should make the formulas work. You may want t
record doing this, then copy the statements within the recorded macr
into the Workbook_Open event handler

 

[Dave Peterson]

You have another guess at your other post.

I have an ErlandC Add in I am using on my system. I have
a workbook that uses the user defined functions in the
worksheet. When I send the file via e-mail to anyone else
to use, once they save the file - they get a #NAME? error
anywhere the user defined functions have been used. These
people also have add ins loaded on their PCs. If I go
into each formula and redo the formula on their PCs, it
will work.

How can I make this work without redoing each formula each
time?
Thanks
Vicki