I'm trying to change the location of some custom functions from add-ins to a single file with all the functions saved in the XLStart folder.

The problem is that when I open old files that used the add-ins, the functions all change name to eg.
"'C:\Program Files\Microsoft Office\OFFICE11\LIBRARY\MaxIF.xla'!maxif" instead of just "maxif", which works with the new XLStart functions and was what was previously displayed with the add-in.

I can go through and rename all the functions using "replace" but this is tedious and I have a lot of old worksheets.

Is there any way to get excel to ignore the function location and just display the function name itself.
Thanks