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 Rei...
Formulas and Functions
office 365
bhushan_z's avatar
bhushan_z
Iron Contributor
May 11, 2020
is it possible for u to share the file?
  • 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"

    • bhushan_z's avatar
      bhushan_z
      Iron Contributor
      May 11, 2020
      hmm,
      if formulas are similar, u can correct one of the cell and the drag it across,
      for example, C81 - F81 has similar formulas

Resources