May 11 2020 05:51 AM
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
May 11 2020 06:14 AM
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..
May 11 2020 06:21 AM
May 11 2020 06:22 AM