I managed to extract the following phrase from their official website, and this is what it says:
Note: This Add-in will work with Excel 2007, 2010, 2013 and 2016 for both 32 and 64 bit (PC only). We don't have a MAC version at this time.
As you can see in the statement, the DataPig Excel Explosion will work with the 2016 version of Office even if it's 32 or 64bit. When installing the add-on, the Excel and other Office packages have to be shut down. You can check this as well on their official website.