Excel crashing with large spreadsheets

I have about 1000 rows x 16 columns of data. None of it is formatted but it is being used in 2 graphs. If I click one thing excel will crash for 10 seconds.

My PC should be plenty powerful enough for this (i7 9700k, 16GB ram, ssd) and I'm running 64bit Excel. It's only using 5% of CPU and around 600MB of ram. I don't have any addons running and I've checked for updates.

Is Excel just not optimised for this kind of task?

4 Reset to default

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

You Might Also Like