When an Excel cell shows the formula itself, or keeps an old result, the cause is almost always one of a few settings. Which one applies depends on what ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results