XlXtrFun error when Excel is opened

[Tronen]

Hello:

I'd been using this addin called XlXtrFun for years. It is very useful mainly for interpolate (splines, etc..). Now the problem comes because I suspect this addin doesn't work for 64 bit Excel versions.

When we are trying to load the addin it appears a message when Excel is opened: "The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?" If Yes is selected then Excel closes. If No is select the addin is not loaded.

We web site for the adding is this:

http://www.xlxtrfun.com/XlXtrFun/XlXtrFun.htm

I have tried to contact with support@xlxtrfun.com but this address doesn't work because the web site is a little bit old.

I think it could be possible to make this addin work for a 64 bit Excel. In this sense I have found this site

http://www.dllfoot.com/fixing/xlxtrfun.xll.html

but I don't understand what they try to explain and it is needed to used a suspicious program called DLLEscort_Setup.exe and a process a little bit dark...

Any other ideas would be welcome.

 

[felipeavf]

Hi @ZVI,

Thanks for your great support on that again!

Regarding your comments...

Thank you for testing and for sharing your installation experience.
In my testing Windows Defender antivirus software was used with no such issues.

Yeah, I had a little bit of pain in here to make things work, but seems to run pretty well now, with no issues...

Click the Fx formula bar and select the "XtrFun64 Library" category to view their list and argument details.

Yeah, and actually it works as the same as any other function, just inserting a "=" signal in the cell followed by the first letters of the function (a drop-down list will be shown with the all the functions, including functions within "XtrFun64 Library".

Only two 3D functions are missing: Interp3D and InterpMatrix.

Sorry, I mentioned "a lot", but actually the only one I tested was the Interp3D, because it was exactly the one I'm interested on...
I supposed you worked first on the 1D and 2D functions and left the multi-dimensional ones behind just to make things simpler.

I will add them into the next version, but only if they are supported by XtrFun.dll

I'm not sure what you mean, but I really expect they are supported! There would be any reason to don't be?
Anyways, I'm glad you will give a try!

Thanks!
Felipe.

 

[felipeavf]

Hi @ZVI

Any news regarding the implementation of the two missing functions?
Are they supported by XtrFun.dll?

I appreciate if you can give me any idea of when the next release will be avaliable.
Thank you!
Best regards,
Felipe.
@felipeavf

 

[ZVI]

Hi @ZVI

Any news regarding the implementation of the two missing functions?
Are they supported by XtrFun.dll?

I appreciate if you can give me any idea of when the next release will be avaliable.
Thank you!
Best regards,
Felipe.
@felipeavf

Hi Felipe,

Sorry for the delay in answering.

The Author of XtrFun.dll warned that the DLL is incomplete.
For example, XatY function and extrapolating argumenrs are not supported by DLL at all - I inserted my own code into the EXE to support XatY and extrapolating arguments.

The next release with implementation of the two missing 3D functions will be available this weekend, I'll provide the link here.
It is known that HLP files are not supported in the modern Operating System, rewriting of the XtrFun64.hlp to XtrFun64.chm format is required.
Hope that the XtrFun64.chm help file will be ready and included in the expected release.

Regards

 

[felipeavf]

Hi @ZVI,

Thanks for your update. I have been out for a couple of days. Sorry my delay too.

Thanks for inserting your own code into the EXE file to suport that XatY.
Luckily you don't need to do it for the 3D functions, right?

I don't see any advantage in make the hlp file works, tbh. But supposedly for new users, it can be good. So, if it's not a big deal for you, it's ok, otherwise you can focus on the functions itself.

Thank you!
Regards,
Felipe.

 

[Lexismom]

@ZVI, thanks very much for this solution.

 

[felipeavf]

Hi @Lexismo, nice to see that other people can have the opportunity to use the tool solution that has been created by @ZVI

Cheers!
Felipe.

 

[felipeavf]

Hi @ZVI, any good news regarding the 3D functions?

Thanks!
Felipe.

 

[felipeavf]

Hi @ZVI , how are you doing? I haven't any answer from you for a long time. I suppose you've been too busy to work on this project. Are you still available to develop the solution for the 3D functions?

Hopping to hear from you soon.

Thank you,
Felipe.

 

[Bill_F]

Hi ZVI ,

I just wanted to give you a big thanks for posting your solution for making XlXtrFun work on the latest versions of Excel. I just upgraded from Excel 2010 to MS 365 and was sad to find the XlXtrFun no longer working in the 64bit version. I installed your solution as you described in this thread and was happy to see that I had XlXtrFun back!!!

Thanks again,
Bill

 

[felipeavf]

Hi @ZVI, although I really thank you to develop the 2D functions solution, I would like to check if are you still keen to develop the solution for the 3D functions?

Thank you,
Felipe.