Forum Discussion

PeroZubak's avatar
PeroZubak
Copper Contributor
May 11, 2020

#Name error

Hello,

 

I have a problem with an excel sheet generating #NAME? error. 

So far only occuring on 1 PC and not on several others..

 

What i've done:

Checked all settings so they are the same

Reinstalled office from 64 bit to 32

Defaulting all settings in Excel

Format the sheet to numbers

Checked if formulas were set to Automatic- yes

Ran Ctrl+shift+f9

Ran Ctr+shift+alt+f9

 

Tried the most out there on google, not sure why this is happening.

 

Worst part is if i edit cell and press ENTER the formula works.. But there are simply to many cells to manually do this for

 

Best regards

Pero

Formulas and Functions
office 365

4 Replies

Sort By
    • PeroZubak's avatar
      PeroZubak
      Copper Contributor
      May 11, 2020

      Unfortunately not, 

      i can show a print scr of a small section of it however:

      simply editing cell and pressing Enter gives the correct result.. 

       
       

       

      • PeroZubak's avatar
        PeroZubak
        Copper Contributor
        May 11, 2020
        I temporarly got to a fix by replacing the word "summa" with "summa" which forces the cells to recheck the formula..

        "summa" is swedish for "sum"

Resources