Related Posts
That Friday feeling

DM for referral

"she doesn't have good boobs" †
👀
Additional Posts in Excel Genius
Still don't have xlookup. #fomo
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.





Mentor
Either you're running excel on a toaster, or you're using excel for something it shouldn't
Make sure you have the 64 bit version and not 32 bit. It enables Excel to use more memory and should fix your issue. I haven't had this type of issue for many years thanks to using 64 bit.
Both Excel and your machine have limits, if you max those out you’ll get it to crash every time. That’s why it’s so important to write common sense code/formulas and minimize data and cell usage.
What is the size of your file? You may want to look at using power query.
Yes but not in a very long time. Agree excel is probably not the right tool for whatever you’re building.