+ Reply to Thread
Results 1 to 3 of 3

xlsx file generating error #NAME?

  1. #1
    Registered User
    Join Date
    11-07-2011
    Location
    Arcata, California
    MS-Off Ver
    2011 for MAC version 14.1.0
    Posts
    52

    xlsx file generating error #NAME?

    Greetings Excel Gurus. We have a Business Plan that has been working fine until today. When we opened it up today, most all of the formulas were changed with =_xlfn.IFS in the beginning and the cell represents #NAME? instead of the number. HELP! This of course changes all the data in the worksheets. Excel file is 1.4 MB and wont let me upload to forum. Here is a DL link in dropbox.

    https://www.dropbox.com/s/nlwmq9sa50...acre.xlsx?dl=1

    I cleared the formats and was able to get it below 1MB
    Attached Files Attached Files
    Last edited by ericinarcata; 06-10-2020 at 12:52 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: xlsx file generating error #NAME?

    Did you try to open the file on a computer that has an older version of Excel than the one it was created on?

    Pete

  3. #3
    Forum Contributor
    Join Date
    04-15-2013
    Location
    Singapore, Melbourne
    MS-Off Ver
    Office 365
    Posts
    167

    Re: xlsx file generating error #NAME?

    IFS——This function is only available in office 365 or office 2019. The formulas should be created by an Office 365 or Office 2019 user. If you run it on a lower version, the result will show error value (#NAME) as your Excel application does not support this formula.
    As far as I know, there are 3 options to solve this problem:
    1. upgrading your Office software to a higher version.
    2. uploading your file to Onedrive and use web browser to open it through office live.
    3. change your formulas, using other formulas, such as IF instead.
    Row row row your boat
    Gently down the stream

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 12-23-2022, 04:02 AM
  2. [SOLVED] ADODB.Connection Generating Error on File Located on Cloud
    By masouder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2017, 03:42 PM
  3. Help with code to convert xls to xlsx and continue with xlsx file
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2016, 11:47 AM
  4. [SOLVED] Flawed design?? Generating two column display from xlsx sheet
    By a61morris in forum Excel General
    Replies: 4
    Last Post: 02-12-2014, 01:37 PM
  5. Replies: 3
    Last Post: 01-05-2014, 05:50 AM
  6. zip unzip .xlsx file error
    By IT Researcher in forum Excel General
    Replies: 2
    Last Post: 05-30-2013, 08:35 AM
  7. How to add the columns data of several xlsx files of a folder in another xlsx file
    By ravikumar00008 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-25-2012, 04:29 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1