Excel 2007 .xlsm Workbook crashes in Excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1306126%22%20slang%3D%22en-US%22%3EExcel%202007%20.xlsm%20Workbook%20crashes%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1306126%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Workbook%20created%20in%20Excel%202007%20that%20will%20not%20work%20in%20Excel%20365%3C%2FP%3E%3CP%3EThe%20problem%20seems%20to%20come%20from%20adding%20and%20removing%20rows%20in%20tables%3C%2FP%3E%3CP%3EThe%20program%20will%20add%20the%20data%20to%20the%20table%20but%20on%20the%203rd%20or%204th%20add%20the%20code%20will%20crash%20and%20gives%20me%20the%20following%20error%20message.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Error%20Adding%20row%20to%20table.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F184280i5208F24AB0AFB549%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Error%20Adding%20row%20to%20table.png%22%20alt%3D%22Error%20Adding%20row%20to%20table.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAfter%20that%20the%20I%20cannot%20continue%20with%20the%20program%20as%20it%20will%20not%20respond%20so%20I%20have%20to%20close%20and%20reopen.%3C%2FP%3E%3CP%3ESo%20far%20I%20have%20not%20found%20related%20information%20on%20google%20or%20other%20sites.%3C%2FP%3E%3CP%3EUpdate%3A%20Additional%20googling%20and%20it%20seems%20this%20has%20been%20going%20on%20since%20at%20least%202010.%20Seems%20like%20it%20would%20be%20fixed%20by%20now%20or%20at%20least%20notice%20that%20there%20is%20a%20glitch%20in%20the%20Listsobjects%20so%20don't%20use%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1306126%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Visitor

I have a Workbook created in Excel 2007 that will not work in Excel 365

The problem seems to come from adding and removing rows in tables

The program will add the data to the table but on the 3rd or 4th add the code will crash and gives me the following error message.

Error Adding row to table.png

After that the I cannot continue with the program as it will not respond so I have to close and reopen.

So far I have not found related information on google or other sites.

Update: Additional googling and it seems this has been going on since at least 2010. Seems like it would be fixed by now or at least notice that there is a glitch in the Listsobjects so don't use them.

 

0 Replies