I think I'd either share the addin.

Or move the function into the workbook.

Or convert those formulas to values before distributing the workbook.





Peter wrote:

I have a group that creates a spreadsheet on a machine that has an excel
addin and then distributes that spreadsheet throughout their department. The
department users do not have the excel addin. For users of Excel XP this is
not a problem, values show without difficuties. For Excel 2003 users the cell
(I beleive) recalculates the formula when departmental users open the
spreadsheet. Since they do not have the addin they get a name resolution
error.

Has anyone run into this and does anyone have a solution for this?

--

Dave Peterson