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.

 

[ZVI]

Hi,

The recommendation of the 2nd link has no sense in this case.
That tool is XLL (actually - DLL) AddIn compiled for the Excel 32 bit only.
Theoretically the owner of its C++ source code might recompile the code for the 64 bit version too, but looks like the AddIn is not supported anymore.

What can you do:
1. Install one more Excel 32 bit of another version (say 2010 32bit if you are using 2016 64bit) and use it for the tasks of that AddIn.
2. Try to find alternative VBA code which is good by default for both 32 and 64 bits.
Or even hire someone (the Author?) for developing VBA AddIn with the similar functionality in case it’s too critical.

Regards,

 

[ZVI]

As to the alternative - test the XonGrid Interpolation Add-in which is free and has versions for 32 and 64 bit of Excel.

 

[Tronen]

As to the alternative - test the XonGrid Interpolation Add-in which is free and has versions for 32 and 64 bit of Excel.

Dear Vladimir Zakharov, thank you very much for your help.

I have tried to install XonGrid. Apparently, the INSTALL-Xll.xls works well but any time I try to open Excel again I receive a message that looks like the other one with XlXtrFun:

"The file format and extension of "XonGrid-w64.xll" don't match. The file could be corrupted or unsafe. Unless you trust its source, don't open it. Do you want to open it anyway?

If I say "yes", then the file is opened in text mode with strange symbols (like a compiled file) and there is not any XonGrid 4 interpolation category in fx button. If I say "no" the complement is not loaded.

Provided there is the code I would try to understand what is happening, or better I would try to contact with Author. That seems a much easier option.

Thank you very much again.

 

[cenk1972]

Dear Tronen,
I have the very same problem. I've been using this xlxtrfun for years and i have formulations based on it in many files and i have big problems after switching to excel 2016 64b (while it works well in the office with excel 2016 32b). It would help a lot if you can post here when you find a solution after contacting the author.
Best regards

 

[Erwin1966]

Has there been found a solution to make xlxtrfun work on 64 bit?

 

[PS_Batam]

I have same problem and would like to ask for any updates.
Cheers

 

[Fluff]

xlxtrfun does not work with 64 bit versions of Excel & that is unlikely to change.

 

[ZVI]

Hi,

Actually, access to the 32-bit XtrFun.dll from the 64-bit version of Excel is possible.
My testing of the only Interp() function was successful.
Two files were created for that: XtrFun64.exe (IPC - interprocess communicator) and prototype of the Excel AddIn XtrFun64.xlam

List of used files:
XtrFun.dll - from the original source
XtrFun64.xlam - VBA AddIn (testing prototype) instead of the XlXtrFun.xll
XtrFun64.exe - IPC

Self-registration of IPC requires XtrFun64.exe to be run as administrator only once.
Both 32 and 64 bit of Excel is supported without any changes.

In theory, the following functions from XtrFun.dll can be supported in Excel 64 bit:
ddydx
dydx
IndexOfClosestValue
Interp
Interp3D
InterpMatrix
Interpolate
Intersect
LookupClosestValue
LookupClosestValue2D
Pfit
Spline
Triangles
XatY

Not sure if anyone interested in this way (let me know),
and if I’ll be such a hero to implement all of that in the nearest future.

 

[felipeavf]

Hi,

Actually, access to the 32-bit XtrFun.dll from the 64-bit version of Excel is possible.
My testing of the only Interp() function was successful.
Two files were created for that: XtrFun64.exe (IPC - interprocess communicator) and prototype of the Excel AddIn XtrFun64.xlam

List of used files:
XtrFun.dll - from the original source
XtrFun64.xlam - VBA AddIn (testing prototype) instead of the XlXtrFun.xll
XtrFun64.exe - IPC

Self-registration of IPC requires XtrFun64.exe to be run as administrator only once.
Both 32 and 64 bit of Excel is supported without any changes.

In theory, the following functions from XtrFun.dll can be supported in Excel 64 bit:
ddydx
dydx
IndexOfClosestValue
Interp
Interp3D
InterpMatrix
Interpolate
Intersect
LookupClosestValue
LookupClosestValue2D
Pfit
Spline
Triangles
XatY

Not sure if anyone interested in this way (let me know),
and if I’ll be such a hero to implement all of that in the nearest future.

Hi @vladimir,

When you said:

Two files were created for that: XtrFun64.exe (IPC - interprocess communicator) and prototype of the Excel AddIn XtrFun64.xlam

How do I suppose can create these files?

Thank you.
Felipe.