My excel Mac crashing if I run VBA macro that has looping formula

My file is crashing if I run VBA macro that has looping formula. My excel mac version is the update one version 16.31   I try to press esc twice and CTRL+. to stop the VBA macro calculation, howeve...