Hello, I have an excel file for work that contains macros. Whenever I enable macros, it then only allows me to open it in 'Read-Only' format. I just downloaded the Office 365 Personal today because I was told by a tech that it would properly open macros. So as far as I know, it is the most updated version of Office 2016. I am running a Macbook Pro on El Capitan 10.11.1.

Excel 2016 for Mac, like all of the other more modern versions of the Excel application, employs a series of tabs at the top of the window that let you navigate through the various settings and tools in the program. In the Excel Preferences shown below, click the Ribbon icon. In the Show or hide tabs, or drag them into the order you prefer: box shown below, enable the Developer checkbox. It’s awesome, now accountants and economists can switch to Mac OS X without having to host a virtual machine with Microsoft Excel.

Does anyone know of anyway to open this properly? The contact support I did talk to couldn't resolve it and sent me to 'Professional Support' who said I would have to pay for a Business 365 just so I could get 'Business Support' and they could hopefully fix my issue. Not sure what kind of lame support that is, but they recommend that I come on here to see if my question could get resolved. It was also the only free resolution they provided. Any help would be greatly appreciated! The tech didn't ask enough questions. There is now Office 2016 (which is for Windows) and Office 2016 for Mac.

The Mac version has feeble support for VBA, though it is gradually improving with every update. You'll have much better luck with Office 2011, which has 99% of VBA supported. It may be possible to downgrade through your Office 365 subscription. Please try this: • Close all Office programs. • Open a web browser and sign in to your Microsoft account at this page: • Click on Services & subscriptions.

• Click on Office 365 settings. • Click on the red Install button.

• Just to the left of the Install button, it should say Office 2016 for Mac. Hopefully, just below that, there will be a link for you to click on Install previous version.

This displays on my page, anyway. • Choose your preferred language and click on the Install button.

Office 2016 will be uninstalled and 2011 reinstalled. If there is no link, it's because MS is tracking whether you actually had 2011 installed through Office 365 previously. If you don't have a link there, I'm afraid you'll have to buy a copy of Office 2011. Quite a few retailers still have stock, just Google for it. In that case the presence of macros may be co-incidental and not the cause of the error message. That message can be triggered by things like the workbook including PivoTable report styles that are not available on Mac or using features that are not programmed for the Mac yet.

Can you customize keyboard shortcuts for onenote on mac. To use a keyboard shortcut that is the same as a default Mac OS X keyboard shortcut, you must first turn off that Mac OS X keyboard shortcut. On the Apple menu, click System Preferences. Under Hardware, click Keyboard, and then click the Keyboard Shortcuts tab.