Forum Discussion
#NAME? error continues to appear
I am constantly getting #NAME? error on files that appear to have correct formulas. This generally happens if I work on a file in the browser and then open it in excel. Example below shows an xlookup formula error. The formula is referencing a tab in the same workbook. This also happens on other formulas. Ive never seen this happen before until recently. Is there something I can do to prevent this from happening?
Why you are entering the formula as array formula? XLOOKUP() doesn't need to enter as array. Can you share a sample file so that we can closely look into your problem?
I dont enter it as an array. Its being changed to that after I open in excel after the browser version. Unfortunately I updated the formulas in that file so I dont have it as an example to share but here is another file with something similar. I dont include the @ in the formula but its being added when the file is downloaded or opened in excel. The formulas is fine in the browser. Sorry its not letting me upload the file.
