I made a function in visual basic that I added to an excel sheet called MyFunctions that I have saved on my system as an Excel Addin.  

If I open Excel and type in a phone number with various punctuation marks, it strips all that punctuation out and returns the numbers only. 

I do not have to have that MyFunctions spreadsheet open because I have it set up as an Add-in. 

When I open Sage 100's Sales Order Entry and click on the magnifying lens next to the Order Number, I get an order number list that I export to Excel using the button next to the printer button at the bottom right. 

The excel window that opens will not allow me to use the Add-in function.  It gives a #NAME? error instead.  

If I copy the sheet in Excel by clicking on the upper left box and right clicking copy, I can paste the sheet into a new excel sheet and the Add-in functions are available.  

Is there a way to have Excel start when called from Sage to have it load the Add-ins?  Is there somewhere that Sage disables it?  

I am on Sage 2018 Advanced.  

Thank you

Chris