ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel add-in function not persisting (https://www.excelbanter.com/excel-discussion-misc-queries/110675-excel-add-function-not-persisting.html)

regexp

excel add-in function not persisting
 
I needed the function DEC2HEX so I added the Analysis TookPak (Excel 2003).
Everything works fine- the function works, I save the workbook and close it.
However, the next time I open the workbook Excel throws a #NAME? error for
the DEC2HEX funtion. I check that the add-in is still there and it is. If I
retype the function it works again. What is causing this? How can I make
Excel remember that function?

Thanks for you help,




All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com