#NAME appears because the function or named range referenced in the formula is not recognized. To solve this problem, check whether the function and variable names used in the formula are correct and exist, and make sure that the named range is correctly referenced.

If there are no problems with the above, it may be because there is a problem with the options in Excel settings. You can try restarting Excel or restoring the default options. In addition, you can try using relative references instead of absolute references or modifying the formula to reduce the number of functions and variables to avoid #NAME errors.