Missing function

[Mr930]

I inherited a spreadsheet that calls a function named INTERP(). I have opened this in Excel 2007 and had no trouble, but in 2010 I get #NAME. I assumed there was some sort of add-in that was missing. An internet search produced no solid results other than there are a lot of custom functions floating around called INTERP(). The funny thing is, on my PC with Office 2007, there are NO add-ins active at all and it works. So I am wondering how this can work in one version of Excel and not another? Has anybody come across INTERP() before?

thanks
Fred Emmerich

 

[starl]

Did you look for COM Addins?
They are under the COM Addins option, not mixed with standard addins

 

[Joe4]

Are you sure it isn't a Custom Function built right into the Workbook itself (in a VBA module)?
If so, it might not work in 2010 if you have not enabled Macros/VBA or if it uses some VBA Reference Library you do not have available or have not selected (under VBA Editor -> Tools -> References). If you compare the selected references on your 2007 computer where it works to the selected references on your 2010 computer that does not work, you may notice a missing selection.

 

[Mr930]

Yes i did, I checked all types of add-ins. The PC with 2007 has no active add-ins at all. Very strange.

 

[starl]

Or a function in the Personal workbook?

 

[Mr930]

I checked and there are no functions in the personal workbook.
I also checked the VBA references, and the same 4 are checked in both 2007 and 2010, the only difference being the version number for the Excel and Office object libraries.

 

[Joe4]

Is there any VBA at all in the Workbook?
Did you check every single Module? Sometimes, I have seen people put fucntions in specific Worksheet modules instead of Standard ones.

 

[starl]

did you refresh calculations in the 2007 workbook after you opened it?

 

[Mr930]

No VBA code at all in any module.

 

[xladept]

Hi Mr930,

Can you single step through it to find and copy the code?