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 !

Dear Excel team, this has been posted already and has 74 comments on it, but you closed it. The reason you are not seeing crash reports is because we have to kill the app and this doesn't seem to generate a crash report.

Issue is as described by 4 pages of comments, please reopen. If not then I have created this as a new issue.

If you attempt to double click in the cell or click in the function bar, then Excel freezes, by keeping the cursor in the cell and removing keyboard entry. Menu's stop working as well, the best you get is a momentary flicker of the menu bars when you try and click them. the only way to work is to then kill (force quit) the app and restart

I am running Excel version 16.13.1 (180523) on macOS High Sierra 10.13.1 on a MacBook Pro 2016, 2.9Ghz i5, 8GB ram, 130Gb free space on SSD.

hi! i want to suggest to you the implementation of a possibility to change excel default settings, e.g. for charts. i’ve talked to your friendly support team about one such example, but they couldn’t help me with something that’s not programmed.

i’m a chemist. like million other natural scientists, students and experts, i work with lots of complex and diverse data, every day. while the modern versions of excel offer many great and even fancy features, customization possibilities have shriveld. the template feature performs badly and really is only useful if applied to the exact same data set-up.
what is good (great even, and - for a mac user - the reason to try my luck with excel rather than numbers) is the possibility to adjust just about anything.
what is bad (and the reason why most of the above mentioned scientists use origin, gnuplot or other, sometimes ridiculously expensive software rather than excel) is that one’s personal preferences on a higher level cannot be introduced to the program. instead each tiny change has to be stupendously adjusted by hand - every time! my personal example from the support-encounter (adding a data label on a curve in a scatter plot (e.g. curve maximum): by default, it will show you the y-value, on the right side of the data point, in the number format of the data set. changing this to my specifications (x-value, above data point, number format with 0 decimal places)) needs 12 extra clicks to change ONE data label. i have done this little task hundreds of times - imagine the amount of time i lost. and there are countless more examples:
- using different source data (e.g. the next column) for a curve will change the curve’s color - why? now i have to chance the format again
- changing the color/format of a set of curves only works by clicking on one after the other (which is impossible, if they are too close together). sometimes i even have to change data values, so i have a place to click at
- applying a template on a new data set leads to ridiculous charts; the template saves for example the axis bounds (so most of my new data ends up tiny or outside the window), but will delete a previously added axis name (so applying a template at any point later than the absolute beginning leads to data loss)

i as a single voice will probably not have an impact on your plans. but i wanted to give you this feedback before giving up and switching to another plotter, which is what pretty much all of my colleagues did. you have a pretty good code base here. now just open it up a little for professional users, and you win back the science community ;)

https://support.office.com/article/upgrade-your-macos-to-access-new-office-365-for-mac-features-f6efc6b6-90f8-4e69-82dd-d0de32a111aa

There is some indication that Office for Mac 2019 will only support the latest current release of macOS plus the previous operating system. This is a formal request from an Enterprise admin to have Microsoft provide support for the current macOS operating system plus the two previous operating systems.

Apple has been absolutely horrendous in documenting and providing the appropriate management tools to deal with major restrictions they've been adding to macOS. This makes it much more difficult to deploy the latest macOS release on day 1. As an example, the majority of our users are still on macOS 10.12 and we are just getting to deploy macOS 10.13 (almost a year later). And that's not for lack of trying or testing.