Consulting

Results 1 to 6 of 6

Thread: Unrecognized text on different computer

  1. #1
    VBAX Regular
    Joined
    Oct 2022
    Posts
    7
    Location

    Unrecognized text on different computer

    I have created “If” statement formulas in excel which works fine on my pc, but when another co-worker tried to open up my exact same file on his pc, it says #NAME?, then when I hover over the error, it says “Unrecognized text”, what could be going on with that issue?

    I made sure the formulas are exactly the same and double checked to make sure they are referenced to the correct cells.

  2. #2
    you can google what are the common cause of #NAME error in excel.

  3. #3
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,294
    Location
    "#Name" errors normally come about spelling issues. Please check spelling including ensuring the names are the same Length and Case
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    VBAX Regular
    Joined
    Oct 2022
    Posts
    7
    Location
    Ok, now my file is all the sudden saying unrecognized text. It was working yesterday, I did not change anything. So why is it all the sudden doing this?

  5. #5
    VBAX Expert
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    895
    Location
    Without seeing the file and with the detail we have currently it is like me asking you "Why is my leg hurting?"

    Can you supply a file or at least a lot more detail i.e.
    What is the formula in question?
    What functions are you using within the If statement?
    What version of Excel does it work/ not work with?
    What was the last thing you did in the file before it stopped working?
    What type of file is it: xlsm, xlsx, xlsb?
    Are the formulae in a table object or just a range?
    Do the formulae look at workbooks other than the one in question?

    Anything else tou can think of that may be relevant...
    If things don't change they stay the same
    Quite often there is a picnic problem (problem in chair not in computer)
    "We were not told it was impossible, so we did it."

  6. #6
    VBAX Regular
    Joined
    Oct 2022
    Posts
    7
    Location
    I cannot send the file as it is on a government server. Also, I found the problem, but not sure why it randomly changes.
    But this is the formula:
    =If(VALUETOTEXT((TODAY()/7-TRUNC(TODAY()/7=(VALUETOTEXT(FORMATS!A3)), “SUNDAY”,If(VALUETOTEXT((TODAY()/7-TRUNC(TODAY()/7=(VALUETOTEXT(FORMATS!A4)), “MONDAY”,If(VALUETOTEXT((TODAY()/7-TRUNC(TODAY()/7=(VALUETOTEXT(FORMATS!A5)), “TUESDAY”,If(VALUETOTEXT((TODAY()/7-TRUNC(TODAY()/7=(VALUETOTEXT(FORMATS!A6)), “WEDNESDAY”, “WRONG”))))

    the error was WRONG was not in quotes. But I am not sure why all the sudden the quotes went missing.

    I had to split up in 2 formulas for all 7 days because of the limitation of chaining the IF function.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •