Adding a function normally works but then the formula stops working for new
functions. If I exit excel and restart, it generally works. There must be
an easier way to fix this problem.

How do I fix it?

How do I stop it from occurring?