Minifs/Maxifs and the new formulas working on new excel file but doesn't work on older excel files

[netanel99]

hello amazing people,

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

the formulas that doesn't work with the older excel file are - IFS Function, MINIFS And MAXIFS Function and the other new stuff added recently for office 2019 and 365..

thanks for any sort of help ,
Netanel

 

[Fluff]

In what way don't those formulas work?

 

[netanel99]

thank you for the help , when it doesn't work, first excel don't auto recognise the formula when I type it, second , even if I write the whole formula it just gives error because the formula doesn't recognised.
but when I open excel (same version) from start menu and use "open file" and open the older excel file then suddenly the Minifs formula recognised when I type and all the already excisting Minifs formulas suddenly goes from error to fully working.

 

[Fluff]

What error do you get in the file that doesn't work?

 

[netanel99]

error :
"#NAME?"

I also tryed to open the file from start menu where it does show the formula right and "save as" and then open the file and still doesn't work .

 

[Fluff]

The only way I can think of where you would get that is if You have two versions of Excel installed & depending on how you open the file it will open in 2019 or the earlier version.

 

[netanel99]

yes it logical but unfortunately it's not my case becase it open excel 2019 on both, and I checked the version exact update number and both are excel 2019 and the same.
I just triple checked and both are
excel 2019 pro plus,
version: 2101
build: 13628.20448

 

[jasonb75]

Have you checked your installed programs through the control panel to confirm that there is only one installation?

I see the same version and build numbers on office 365 so my previous suggestion appears to be an unreliable way of identifying different versions

When you check the installed programs, check the whole list carefully for anything with the Office or Excel logo rather than looking / searching where you think it should be. I've noticed that my current installation is listed as 'Microsoft 365', naturally, if I search for 'Office' or 'Excel', the installed version is not found.

 

[netanel99]

oh . got ya, I've checked in all the variant I could think of, I've found : microsof office pro 2019 with no MB indication and also office 19MB so I guess it's ok.
thanks for all the in depth help , I'll eat the fish , maybe I'm saying the phrase wrong, is it eat the fish? donno , I guess I'll just live with it. Hope those will be our problems

 

[jasonb75]

Best thing I can suggest is to uninstall anything related to office that you can find in the program manager, then see if you can still open a workbook from the file browser. If you can then it would mean that there is still another version hidden away somewhere.

Once you are sure that you have uninstalled everything, restart your computer before installing the correct version that you want to use. (I don't think that restarting is strictly necessary with office installations but it never hurts).

Hopefully a clean install will resolve it.