Excel 365 for Windows vs Mac

[TheSardOz]

Hi all,

I would like to know if excel 365 for Mac is exactly the same as the one for Windows.

More specifically, does the Mac version support all the new formulas of excel 365, like filter function and all the other functions only available to 365?
Also does the Mac version support User forms?
If I have a macro that saves files to a computer folder, will the file path still be the same on mac as windows?

Thank you in advance!

 

[Kyle123]

No it's not, frankly it's quite a poor imitation - I run office in a windows VM on my mac as it's much better.

The mac version supports the functioning of userforms, but they cannot be edited in VBA - ActiveX controls are not supported on worksheets
No, it will not be the same path on a mac as windows, both the folder structure and path separators are different

You cannot reasonably expect VBA written on windows to function on a Mac without testing it.

 

[TheSardOz]

No it's not, frankly it's quite a poor imitation - I run office in a windows VM on my mac as it's much better.

The mac version supports the functioning of userforms, but they cannot be edited in VBA - ActiveX controls are not supported on worksheets
No, it will not be the same path on a mac as windows, both the folder structure and path separators are different

You cannot reasonably expect VBA written on windows to function on a Mac without testing it.

Thank you for your feedback!

 

[Jim Gordon]

Here's a summary table for developer oriented topics:

Feature	Mac	Windows	Comment
Latest cell formulas	Yes	Yes
Active-X	No	Yes
COM add-ins	No	Yes
PowerQuery Connections	Rolling out now	Yes
Data model	No	Yes	A workbook having a data model will not lose the data model in Mac Excel, but nothing can be done with the data model.
UserForms	Yes	Yes	No Mac interface to build or edit UserForms. Mac can make and edit in VBA.
Javascript	Yes	Yes
AppleScript	Yes	No
Objective-C	Yes	No