Macro files are not running in Excel 2016

I have 48 macro enabled files which was created in 2013 excel version.

Now,I have shifted to excel 2016 version.But No VBA or macro-enabled files are working on excel 2016.

Can anyone help me ? How will it work on 2016 excel version ?

I have insert developer tab on excel file.

My first guess is that it sounds like you shifted from 32-Bit Excel 2013 Version to a 64-Bit 2016 Version.. But this should impact only certain files that use 32-Bit components that aren't available in 64-Bit Excel.

However, you will have to tell us a bit more about the issue. Can you tell what error code you are getting? Also, the line of code that is erroring out.