How often does your Excel crash?
Have been building some extensive models and my excel crashes 5-6 times a day. Have to exit from task manager and usually restart my laptop 5+ times a day. I probably spend 2 hours a day just waiting for excel to respond and it’s a huge damper in productivity.
I always open a blank sheet and turn formulas to manual and enable iterative calcs. Then I’ll open whatever file I want to work in.
Any suggestions? I have 32GB of RAM and all drivers and software things are up to date. Use a Dell but it’s an old model.
Excel crashes can be frustrating, but there are a few tips you can try to fix the issue. Here are some suggestions:
Update Excel: Make sure that you have the latest version of Excel installed on your computer. Check for updates and install them if any are available.
Disable Add-ins: Some add-ins may conflict with Excel and cause it to crash. Try disabling all add-ins and see if Excel runs smoothly. If it does, then re-enable the add-ins one by one to find the problematic one.
Repair Excel: Use the built-in Repair option to fix any corrupted or damaged files. You can do this by going to Control Panel > Programs > Programs and Features > Microsoft Office > Change > Repair.
Check for conflicting programs: Other programs running on your computer may interfere with Excel. Check your task manager for any conflicting programs and close them if necessary.
Clear temporary files: Excel may crash if it runs out of memory or if there are too many temporary files. Clear your temporary files and increase your available memory to prevent Excel from crashing.
Regards,
Rachel Gomez
Did you misspell your username? Asking for a friend.
I like to think of it as the equivalent of the Clark Kent disguise, there's no way we'd recognize the name as Rachel Gomez when it's clearly Rachel Goemz.
Do you have CIQ, pitchbook, macabacus, or other plugins? Try opening the plugin manager (you have to close all your office programs), unplug everything, then re-plugging everything. Works like a charm when my excel crashes a lot
Get a better laptop, if possible. Not all RAM is created equally. In addition it's probably running on an old CPU which would also cause slower calcs. CPUs have come leaps and bounds even from a few years ago.
Always check and remove hidden names. Do the below, then go into alt m n name manager, delete all the bad names (keep the relevant ones).
in excel, open VBA (alt F11) -> right click open -> use the code below (or sth similar) and run it -> get out of vba -> open name manager (ctrl F3)
You’ll probably see 1000+ hidden names. Delete all of them.
Sub ShowAllNames()
Dim n As Name
For Each n In ActiveWorkbook.Names
n.Visible = True
Next n
End Sub
File size will go down and no holding enter key for the “name is already defined” messages!
This is a good one to check. Also check to see if formatting got copied to all columns and/or rows that can also add tons of size to files. If you clear all for all rows or columns you’re not using - you gotta save first before you see the file size go down.
Doing this now to see. Did it in one file and saw a few names. Interesting - had no idea this was a thing
Ratione enim dolorem nemo soluta et. Molestias voluptatum recusandae inventore excepturi aut. Tempora sunt ut omnis laborum culpa est qui est.
Officiis et non dicta ducimus. Inventore officia recusandae est numquam facilis accusantium dolores voluptates.
Rem dolores maxime quidem occaecati. Officia iste mollitia quas eius qui recusandae. Et minima autem debitis tempora odio.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...