Build bulletproof workbooks with named ranges, dynamic tables, and Excel's built-in error-checking tools.
If Excel is not recognizing functions after reboot, change calculation settings, disable Show Formula, run Excel Troubleshooter, etc.