Excel 2024 stops responding with macro workbook from previous Excel version

Hello, I have an issue related to contract work I do.  The main contractor creates a workbook that has macros for several rows in the workbook.  I've used these workbooks for years running Excel 2016.  I had to get a new laptop and so I had to get the newest version of Office.  I bought Office when I bought the laptop and installed it.  

When I try to input data in the row with macros, Excel freezes (not responding) and I have to close it using the task manager.  Sometimes it will crash all together, but mostly it freezes.  I've tried contacting Microsoft support via chat and they insisted there was a problem with workbook and was not a compatibility issue between the older and new version of Excel.  

This has happened after I enabled macros.  I have tried updating Excel and am currently trying to update Windows 11.

Has anyone experienced this and is so is there a fix?  I did try searching for this issue prior to creating this conversation.  Thanks in advance for any help.