Up until recently, I used a PC running the latest version of Windows 10 with Office 365, including the fully installed Office applications (Word, Excel etc).
I now use a MacBook Pro running the latest version of macOS Sierra with Office 365, including the fully installed Office applications (Word, Excel etc) for Mac. Updates are set to automatically download and install.
.xlsm files containing macros created in the latest version of Excel on a Windows 10 PC, won't currently work as intended in the latest version of Excel (version 15.34 17051500) on a MacBook Pro running the latest macOS Sierra.
This is the first image I see after opening a .xlsm file on a MacBook Pro.
I want to enable macros, as I trust the source who sent me the .xlsm file, so I click "Enable Macros".
I then receive this image after clicking "Enable Macros".
As you can see, the only options I have are to click "Cancel", which completely closes the .xlsm file, or to click "Open as Read-Only", which automatically disables the macros.
To click "Open as Read-Only" means that the .xlsm file cannot be used as originally intended. For example, drop down boxes do not function as originally intended and therefore relevant data will not display.
Microsoft and Apple to work together to provide the appropriate updates to Excel on a Mac.
Installing a Virtual Machine on my MacBook Pro, such as Parallels. Then installing the latest version of Windows 10 onto the Virtual Machine. I will then have 2 operating systems running independently on my MacBook Pro, allowing me access to both operating systems at the same time. This will cost money for the purchase of Windows 10 and monthly/annual subscription to Parallels, as well as the time spent setting up.
Alternatively, purchase Windows 10 standalone and install via Bootcamp on my MacBook Pro. This will cost money for the purchase of Windows 10, as well as the time spent setting up.
I love Microsoft. I love Apple. If you can please both work together to provide the appropriate updates to Excel on a Mac, this would be the ideal solution.
I hope that I'm the only one that currently has problems working with .xlsm files containing macros, using Excel 2016 on a Mac.
Are you or have you experienced the same or similar problems?