Home

Excel 2013 crashing

%3CLINGO-SUB%20id%3D%22lingo-sub-755715%22%20slang%3D%22en-US%22%3EExcel%202013%20crashing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-755715%22%20slang%3D%22en-US%22%3E%3CP%3EAfternoon%2C%20I%20was%20asked%20to%20see%20why%20Excel%202013%20would%20crash%20when%20attempting%20to%20sort%2Fvlookup%20a%20large%20amount%20of%20data.%26nbsp%3B%20Would%20updating%20the%20user%20to%20Excel%20365%20help%20to%20eliminate%20the%20crashed%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-755715%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-755938%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202013%20crashing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-755938%22%20slang%3D%22en-US%22%3E%3CP%3EMicrosoft%20made%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fexcel%2Fconcepts%2Fexcel-performance%2Fexcel-performance-and-limit-improvements%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Emajor%20improvements%20to%20the%20speed%20of%20lookup%20functions%20(including%20VLOOKUP)%20in%20the%20subscription%20version%20of%20Excel%202016%3C%2FA%3E.%20if%20you%20are%20doing%20many%20thousands%20of%20lookups%20on%20a%20million%20rows%20of%20data%2C%20the%20improvement%20can%20be%20a%20thousand-fold%20or%20more.%20Improvements%20were%20also%20made%20to%20make%20Excel%20more%20resistant%20to%20freezes%2C%20crashes%20and%20hangs.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20definitely%20recommend%20upgrading%20to%20Excel%202016%20on%20an%20Office%20365%20subscription%2C%20especially%20given%20the%20reported%20problem.%20Excel%202019%20(perpetual%20license%20version)%20will%20also%20have%20these%20improvements%2C%20but%20won't%20be%20getting%20any%20subsequent%20feature%20updates.%3C%2FP%3E%3C%2FLINGO-BODY%3E
PKeller
New Contributor

Afternoon, I was asked to see why Excel 2013 would crash when attempting to sort/vlookup a large amount of data.  Would updating the user to Excel 365 help to eliminate the crashed?

1 Reply

Microsoft made major improvements to the speed of lookup functions (including VLOOKUP) in the subscription version .... if you are doing many thousands of lookups on a million rows of data, the improvement can be a thousand-fold or more. Improvements were also made to make Excel more resistant to freezes, crashes and hangs.

 

I definitely recommend upgrading to Excel 2016 on an Office 365 subscription, especially given the reported problem. Excel 2019 (perpetual license version) will also have these improvements, but won't be getting any subsequent feature updates.