Sounds like an auto run macro. These can sometimes be
stopped by holding the shift key down whilst double
clicking to open the file in Explorer. Or you can change
the security settings in Excel to prompt before running
macros.

plus

There appears to be VBA code trying to run which is coded
incorrectly & trying to perform an action on a range.