How to remove references to ExcelDNA functions? As an "exported" sheet?

May 6, 2013 at 10:12 PM
Greetings. I'm converting my vba library of database funcions into ExcelDNA and all is working wonderful, as now the functions are ThreadSafe the recalc time has dropped to 25%! (4 cores pumping results!)

But now, I need to drop all the functions called fromExcelDNA in order to "publish" my reports. With the VBA version of the functions I just breaked the link with my .xla in one line of code. But now, I can't figure it out what to do with the .xll based ones (besides doing a manual search for any of the functions on every cell formula and replacing it with the current cell value, which is a too long process that takes away the time recovered with the speed of the functions).

Any idea?
Coordinator
May 6, 2013 at 10:18 PM
Hi,

I don't know of way to 'unlink' .xll add-in functions that way.
I think you'd have to automate the search/replace sotry, or use Copy/Paste as Values to save the sheet without the formulae.

-Govert