+ Reply to Thread
Results 1 to 6 of 6

Minifs and the new formulas working on new excel file but doesn't work on past excel files

  1. #1
    Registered User
    Join Date
    05-12-2013
    Location
    Tel Aviv, Israel
    MS-Off Ver
    Excel 2019
    Posts
    93

    Minifs and the new formulas working on new excel file but doesn't work on past excel files

    hello amazing people,

    thanks for all the help, you guys are always great, wanted to ask you the question on the title, also note that both excel files- the new one and the older one is in .xlsm - how can I make the older file get the new formulas like if I open new excel file.

    IFS Function, MINIFS And MAXIFS Function and the other new stuff..

    thanks a bunch ,
    Netanel
    Last edited by netanel99; 02-27-2021 at 11:00 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,487

    Re: Minifs and the new formulas working on new excel file but doesn't work on past excel f

    The new functions are in Excel 365 and 2019. You have not attached any files ...
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    05-12-2013
    Location
    Tel Aviv, Israel
    MS-Off Ver
    Excel 2019
    Posts
    93

    Re: Minifs and the new formulas working on new excel file but doesn't work on past excel f

    Hi AliGW, I use office 2019 pro , the file is very big, i generated the file 2 years ago, the new formulas don't work on it.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,487

    Re: Minifs and the new formulas working on new excel file but doesn't work on past excel f

    OK.

    1. Update your forum profile - it says Excel 2016 at the moment.
    2. Create a SAMPLE workbook that demonstrates the issue. We do NOT want or need to see your entire dataset. Desensitise the sample data.

    You need to be prepared to make an effort if you want us to make an effort to help you, for FREE!

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Minifs and the new formulas working on new excel file but doesn't work on past excel f

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Glenn



  6. #6
    Registered User
    Join Date
    05-12-2013
    Location
    Tel Aviv, Israel
    MS-Off Ver
    Excel 2019
    Posts
    93

    Re: Minifs and the new formulas working on new excel file but doesn't work on past excel f

    Yes, sorry Mr, second sorry for that mistake, I wanted to delete but didn't knew how to, it asked in one more forum with a bit of changes of words but you'r right It kinda the same, my mistake, won't happen again.

+ 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: 1
    Last Post: 08-03-2018, 09:07 AM
  2. Replies: 0
    Last Post: 05-06-2015, 08:07 AM
  3. This code doesn't work when when i share the excel file ,,any hints
    By gostavee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2015, 05:13 PM
  4. [SOLVED] Copy Past cells doesnt work in EXCEL file.
    By blake20 in forum Excel General
    Replies: 2
    Last Post: 08-26-2014, 02:26 AM
  5. Excel Formula Doesn't work when Source File is closed
    By Tejas.T in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-30-2014, 02:38 PM
  6. [SOLVED] NOT WORKING..Getting XLA files to work with Excel
    By Brett Smith in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-25-2006, 03:55 PM
  7. Excel Filtering doesn't work with large files
    By Andy in forum Excel General
    Replies: 6
    Last Post: 03-29-2005, 03:06 PM

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