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
Occasional 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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies