#NAME? Problem : Replacing "Interpolate()" from XlXtrFun.xll with an .xlam "Interpolate()"

Hi,

Previously I've created a large number of spreadsheets that made use of the linear interpolate function "Interpolate" from the XlXtrFun.xll addin on my PC running Excel 2003.

I've recently moved to a Mac and am running Excel 2011. XlXtrFun.xll is not available for the mac, so I have LOTS of spreadsheets that result in "#NAME?" for references to the "Interpolate" function.

As a workaround, I have a Visual Basic function as a .xlam, and have it installed it as an add-in.

When I load one of the old spreadsheets - all references to =Interpolate(.....) result in #NAME? in the cells. If I click to edit the function, do not change anything, and hit enter - the interpolate runs correctly. Alternatively, I can type in =Interpolate(.....) in an empty cell and it works correctly. So it seems the function is active and available.

How can I get all of the cells to run the interpolate function without having to "edit" each cell formula? I've tried a recalculate without success.

Thanks for your help!

Jim

Originally Posted by shg

Try replacing = with =

That does work. Thanks...

Still like to get them to automatically calculate when I load the spreadsheets. Any ideas?

Originally Posted by shg

Once you have them pointed at the correct source (which is now the add-in) and the workbook is saved, it should work fine when re-opened as long as the add-in is loaded.

So no way to duplicate the "location" of the previous interpolate so that I don't have to do the global replace step?