![]() ![]() 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. So it seems the function is active and available. Alternatively, I can type in =Interpolate(.) in an empty cell and it works correctly. ![]() If I click to edit the function, do not change anything, and hit enter - the interpolate runs correctly. When I load one of the old spreadsheets - all references to =Interpolate(.) result in #NAME? in the cells. xlam, and have it installed it as an add-in. XlXtrFun.xll is not available for the mac, so I have LOTS of spreadsheets that result in "#NAME?" for references to the "Interpolate" function.Īs a workaround, I have a Visual Basic function as a. I've recently moved to a Mac and am running Excel 2011. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |