Troubleshooting

Also see the Formulas > Troubleshooting page.


DATEDIF Function

The DATEDIF function is only available for backwards compatibility and should never be used.
Instead of using this function you can find alternative formulas on the page under Advanced Functions.


CEILING.PRECISE Function

The CEILING.PRECISE function is only available for backwards compatibility and should never be used.
Instead of using this function you should use CEILING.MATH


_xlfn prefix

search link, "An-xlfn-prefix-is-displayed-in-front-of-a-formula"



User Defined Functions = #NAME!

You cannot have the code module the same name as the user defined function



VBE Refresh Bug

fastexcel.wordpress.com/2011/06/13/writing-efficient-vba-udfs-part-3-avoiding-the-vbe-refresh-bug/


Every time a user defined function is updated the VBE title bar has [Running] appended to it.
Once the UDF function has completed the title bar reverts back to what it was before.
This updating of the title bar is unnecessary and will slow down your user defined function(s).
To avoid this happening close the VBE Editor then save and close the workbook.
You can also see a speed improvement when you initiate the calculation from VBA using Application.Calculate



© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext