#Name error

%3CLINGO-SUB%20id%3D%22lingo-sub-1379617%22%20slang%3D%22en-US%22%3E%23Name%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379617%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20problem%20with%20an%20excel%20sheet%20generating%20%23NAME%3F%20error.%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20far%20only%20occuring%20on%201%20PC%20and%20not%20on%20several%20others..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EWhat%20i've%20done%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EChecked%20all%20settings%20so%20they%20are%20the%20same%3C%2FP%3E%3CP%3EReinstalled%20office%20from%2064%20bit%20to%2032%3C%2FP%3E%3CP%3EDefaulting%20all%20settings%20in%20Excel%3C%2FP%3E%3CP%3EFormat%20the%20sheet%20to%20numbers%3C%2FP%3E%3CP%3EChecked%20if%20formulas%20were%20set%20to%20Automatic-%20yes%3C%2FP%3E%3CP%3ERan%20Ctrl%2Bshift%2Bf9%3C%2FP%3E%3CP%3ERan%20Ctr%2Bshift%2Balt%2Bf9%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETried%20the%20most%20out%20there%20on%20google%2C%20not%20sure%20why%20this%20is%20happening.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorst%20part%20is%20if%20i%20edit%20cell%20and%20press%20ENTER%20the%20formula%20works..%20But%20there%20are%20simply%20to%20many%20cells%20to%20manually%20do%20this%20for%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3CP%3EPero%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1379617%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1379669%22%20slang%3D%22en-US%22%3ERe%3A%20%23Name%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379669%22%20slang%3D%22en-US%22%3Eis%20it%20possible%20for%20u%20to%20share%20the%20file%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1379691%22%20slang%3D%22en-US%22%3ERe%3A%20%23Name%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379691%22%20slang%3D%22en-US%22%3E%3CP%3EUnfortunately%20not%2C%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20can%20show%20a%20print%20scr%20of%20a%20small%20section%20of%20it%20however%3A%3C%2FP%3E%3CP%3Esimply%20editing%20cell%20and%20pressing%20Enter%20gives%20the%20correct%20result..%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1379708%22%20slang%3D%22en-US%22%3ERe%3A%20%23Name%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379708%22%20slang%3D%22en-US%22%3Ehmm%2C%3CBR%20%2F%3Eif%20formulas%20are%20similar%2C%20u%20can%20correct%20one%20of%20the%20cell%20and%20the%20drag%20it%20across%2C%3CBR%20%2F%3Efor%20example%2C%20C81%20-%20F81%20has%20similar%20formulas%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1379715%22%20slang%3D%22en-US%22%3ERe%3A%20%23Name%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379715%22%20slang%3D%22en-US%22%3EI%20temporarly%20got%20to%20a%20fix%20by%20replacing%20the%20word%20%22summa%22%20with%20%22summa%22%20which%20forces%20the%20cells%20to%20recheck%20the%20formula..%3CBR%20%2F%3E%3CBR%20%2F%3E%22summa%22%20is%20swedish%20for%20%22sum%22%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

4 Replies
Highlighted
is it possible for u to share the file?
Highlighted

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

 
 

 

Highlighted
hmm,
if formulas are similar, u can correct one of the cell and the drag it across,
for example, C81 - F81 has similar formulas
Highlighted
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"