I have been using Office for Mac 2011 and Office for Windows 2010 Pro. Both of these open Excel files exported from Microsoft Dynamics CRM. During use of the Office 2016 for Mac Preview, the Excel files exported from Microsoft Dynamics CRM would not open. I reported this issue to the Office developers, with no apparent resolution. I am told by sales support that there is no sort of compatibility pack which may help with this issue. To the developers know why files from Microsoft Dynamics CRM are not recognized? I am not able to buy Office 2016 for Mac without this feature working. I would be open to trying the Office 365 version first to see if it works yet, if a resolution is reached.
Thank you.