I have created a excelsheet with lots of custom functions.

Everything worked perfect but suddenly all the cells with custom functions display #value!.

When I go to the cells and press enter (maintaining the custom formula), the result is again displayed correctly.

How can I avoid this and what is the reason for this to happen?

Thanks!