Macro Problem

Frequent Contributor

I have an excel file with macros stored in Google Drive. 


The file operates normal in my company's computer (which is Excel 2016 16.0.4738.1000 32 bit). However, when the same file open at my home/personal PC (which is Office 365 16.0.10827.20118 32 bit), it says that there is a kind of corruption and the file needs to be repaired. When say yes to the repair, Excel erase all the macros. 


My colleagues using MacBook which is also Office 365 (version 16.18 (181014)). He do not have same problem. 


Why there is such problem? Please help. Thanks a lot.