HOLD SHIFT key to disable auto_run excel vba macros not supporting anymore.
Is it because of any recent update or do I have to repair or re-install office 365.
I'm not sure but the way it works for me is to open the workbook using the Open command in Excel not to open it directly from the local drive.
Please check out this link.
Hope that helps