Excel formulas and recalculation

[Guest]

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]

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.

 

[Jerry W. Lewis]

When a workbook is opened by the same or earler version than the version
that saved the workbook, Excel only recalculates volatile formulas until
data is changed. All formulas will be recalculated if it is opened by a
later version than the one that saved it. Thus you could bypass the
problem if the workbook were created in an instance of Excel 2003 that
has the add-in.

Jerry

 

[Guest]

Thanks for the info, we'll test this out an post the results.