EXCEL 2019 CRASHES WHEN SAVING CODE
EXCEL 2019 CRASHES WHEN SAVING WINDOWS

Reg.exe add вЂњHKCUSoftwareMicrosoftOffice16.0ExcelOptionsвЂќ /v вЂњForceVBALoadFromSourceвЂќ /t REG_DWORD /d вЂњ1вЂќ /f You can check the reasons listed above and try to simply solve the error: 1. Solution 1: Simple Fixes to Excel Document not Saved Issue. So, it is necessary for you to make out what caused your Excel cannot be saved. You can perform the same changes by running these 3 commands: Your Excel file is corrupted and cannot be saved.

HKEY_CURRENT_USERSoftwareMicrosoftOffice16.0ExcelOptions HKEY_CURRENT_USERSoftwareMicrosoftVBA7.0Common The following registry changes were needed: We were able to fix the issue by following these MS articles: Thanks to Paulina from Microsoft for helping me find this solution вЂ“ itвЂ™s saved my bacon a few times now!Д©4 comments on вЂњ Excel crashes when enabling macrosвЂќДЇiles containing macros and that linked to other worksheets crashed Excel in vbe7.dll. Hey presto, when you then load your spreadsheet youвЂ™ll be able to enable macros, and Excel wonвЂ™t crash.Then just close the Visual Basic window, save the spreadsheet and close Excel.

Then scroll down in the вЂProjectвЂ™ window, right click on вЂModulesвЂ™, then Insert a new module.

Then on the вЂGeneralвЂ™ tab, untick вЂCompile On DemandвЂ™, then click OK.

In the вЂDeveloperвЂ™ ribbon, click вЂVisual BasicвЂ™.

Open the Excel spreadsheet (but donвЂ™t enable macros yet).

There a a couple of solutions to this:ДЎ) Before enabling the macros try adding a new blank sheet, and then save the spreadsheet, reload, and sometimes it corrects itself.

EXCEL 2019 CRASHES WHEN SAVING CODE

Yes I know itвЂ™s VBA code which is interpreted and not compiled, but IвЂ™m over-simplifying here. This is seemingly caused by a corrupt compile of the macros. Sometimes Excel just crashes when opening the file, even without enabling macros. IвЂ™ve found that the spreadsheets tend to stay working whilst youвЂ™re looking at them (if you donвЂ™t click вЂEnable ContentвЂ™), however it crashes when you try and do anything useful such as copy/paste, etc.

EXCEL 2019 CRASHES WHEN SAVING WINDOWS

Unfortunately Windows never seems to be able to find the elusive solution that we need. When I click вЂEnable ContentвЂ™ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious вЂњMicrosoft Excel has stopped working, Windows is checking for a solution to the problemвЂќ message. IвЂ™ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros.

Excel 2019 crashes when saving