Excel for Mac version 16.15 does not open xlsm files from Excel for Windows !

Excel has a very serious error:
Do not open the xlsm files maked with Excel for Windows, please correct it... !!!
 

I have tried it with all my previous excel macros files and in all it sends me a message of ERROR, when accepting that, Excel proceeds to repair it deletes all the macros that you have programmed in VBA !!!

What kind of error is that ???

PLEASE CORRECT THAT HORROR !!!! ...

The exact message is the following:

Notice: 
We have found a problem with 'book.xlsm' content. Do you want us to try to recover as much content as possible? If you trust the origin of this book, click Yes.

When I answering YES, all the VBA code is deleted and lost !!!
Very careful Danger of losing your VBA macros !!! 


Microsoft: ¡ please correct this error !

The next version of MacOS will will not allow the editing of UserForms in Excel so I've installed a virtual machine (Parallels) with the current MacOS which I will not update when the new version comes out. I can currently run all of my excel spreadsheets (Excel for Mac 2011) using this (they all run flawlessly) and will be able to update my main OS to the new version.

Actually, I have installed all of my 32 bit applications on the virtual machine.

This a lot cheaper than buying a dedicated Windows computer.

Now I have all the benefits - two computers in one with all the advantages of both.

(I have no form of business association with Parallels.)

I Purchased Office 2019 (one time purchase) on 24 Jan 2019
at Mac Centre Norwood (Adelaide South Australia) Apple Shop

Having Problems so for now have gone back to Office 2011 Default Excel AND VERY WORRIED THAT NEXT MACOS WILL NOT SUPPORT THAT OLD OFFICE VERSION:

Excel in Microsoft Office 2019 is slow to open - two minutes versus 8 seconds in Office 2011 if opening a saved workbook on my Mac book pro MacOS Mojave 10.14.2 by double clicking workbook file icon. Workaround seems to be opening Excel first from which the file is opened but that still takes 8 seconds whereas with Office 2011 it is immediate if Excel is opened first.

I hypothesise that the delay could be related to Office 2019 common services trying to handshake with system resources in the Mojave OS when Office expected the Sierra OS.

A second big issue is after extensive changes were made in the VBA embedded in an Excel workbook, admittedly running in Compatibility Mode, the Workbook could not be saved and so the work was lost. Apple Case ID: 100742389363 31 Jan 2019. Use that number to review your case.

If a workbook is enhanced with VBA changes using Excel in Office 2019, one might want that workbook to be portable to another Mac with a different OS or even a Windows machine. Multiple platform utility is one of the big selling points of implementation in Excel. It seems such an enhanced workbook is corrupted from the perspective of even the earlier mac Excel in Office 2011. The change tested was simply placement of linefeeds in an alert dialogue!

Annoying too is the width of text strings in alerts & dialogues is much shorter than in Office 2011 and also has unexpected unnecessary line feeds fragmenting text.

I downloaded the package directly from Microsoft, not realising I could have ordered it on the Apple App Store from which updates to eventually fix such issues might have been automatic. How do I organise getting fixes to the product at some point?

Noticed too having opened an existing significant Word document created in Office 2011, that in Office 2019 it can not update the Index for that otherwise unchanged document.

I Purchased Office 2019 (one time purchase) on 24 Jan 2019
at Mac Centre Norwood (Adelaide South Australia) Apple Shop

Having Problems so for now have gone back to Office 2011 Default Excel:

Excel in Microsoft Office 2019 is slow to open - two minutes versus 8 seconds in Office 2011 if opening a saved workbook on my Mac book pro MacOS Mojave 10.14.2 by double clicking workbook file icon. Workaround seems to be opening Excel first from which the file is opened but that still takes 8 seconds whereas with Office 2011 it is immediate if Excel is opened first.

I hypothesise that the delay could be related to Office 2019 common services trying to handshake with system resources in the Mojave OS when Office expected the Sierra OS.

A second big issue is after extensive changes were made in the VBA embedded in an Excel workbook, admittedly running in Compatibility Mode, the Workbook could not be saved and so the work was lost. Apple Case ID: 100742389363 31 Jan 2019. Use that number to review your case.

If a workbook is enhanced with VBA changes using Excel in Office 2019, one might want that workbook to be portable to another Mac with a different OS or even a Windows machine. Multiple platform utility is one of the big selling points of implementation in Excel. It seems such an enhanced workbook is corrupted from the perspective of even the earlier mac Excel in Office 2011. The change tested was simply placement of linefeeds in an alert dialogue!

Annoying too is the width of text strings in alerts & dialogues is much shorter than in Office 2011 and also has unexpected unnecessary line feeds fragmenting text.

I downloaded the package directly from Microsoft, not realising I could have ordered it on the Apple App Store from which updates to eventually fix such issues might have been automatic. How do I organise getting fixes to the product at some point?

Noticed too having opened an existing significant Word document created in Office 2011, that in Office 2019 it can not update the Index for that otherwise unchanged document.