#Name error

[PeroZubak]

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

[#2]

is it possible for u to share the file?

[#3]

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.. 

[#4]

hmm,
if formulas are similar, u can correct one of the cell and the drag it across,
for example, C81 - F81 has similar formulas

[#5]

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"