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
Bookmarks