Persistent crashes in Excel 2016

I have a very large Excel file with hundreds of VBA macros and 50 or so forms. After working fine for many years it has gradually in the past year (since moving to Excel 2016 64 bit) become unstable. I am strict about backing up my Excel files but the backups have become unrepairable as well even though they saved ok from a decent version. The crashes happen in various circumstances e.g. clicking on a button, clicking in the VBA editor on a particular form, encountering an error when running the program, it's just neither reproducible nor predictable. It seems I will now have to revert to a version 3 weeks old and re-enter all the changes - yuk. Has anyone any suggestions about the cause and repair? The Excel attempts to repair are obviously useless and lead you down the garden path, hoping in vain.

Hi there,

Just a very slim chance!

I have sometimes found that "mysterious" crashes can be cured by cleaning the VBA code with the (free!) VBA Code Cleaner application - it might help in your case.

Regards,

Greg M

Thank you. I am resurrecting an old version and slowly rebuilding the macros, menus and VBA code, checking at every turn. I'm pretty sure now it's a memory issue as once, just once, there was a message saying 'out of memory'. It's pretty bad, even when quitting from a bad file without saving, Excel exits but attempts to repair and open the file again. Excel is wonderful but awful when taken to its extremes I think.