Looking forward to an excel and VBA expert who has been working with office 365 environment in mac for a very long time and can guide me from time to time. for my project but at times get stuck in lot of things, where I don't understand fully as to how to implement functionalities which are already there in the excel but I am not able to use them maybe because of environment or maybe I am not aware of how to use them. I use pivot tables connected to external data sources a ton on Windows, but it does not seem to be supported in Mac 2016. The first time it asked me to activate the license online again which I did however, this has not stopped them crashing constantly. I am designing various data tables, writing few small macros etc. Excel for Mac - Support for external data sources within Pivot Tables. Microsoft Office 2016 for mac (OS X Yosemite 10.10.5) keeps crashing For some unknown reason microsoft excel and word have started crashing constantly a few seconds after restarting.
Support for using microsoft excel through office 365 in Mac.