Why is excel 2010 so slow

Hope doing this will fix Excel slow to respond issue but if in case not then try another solutions. This is another common reason responsible for Excel running slow, leaving plenty of unused formulas like sumifs, countifs, and vlookups around long can served their purpose. So, try converting them to static values and prevent your Excel file from running slow.

Hope after doing the given tricks helps you to fix the Excel slow to respond issue. But if not then make sue of the MS Excel Repair Tool, this is an advanced repair tool to repair corrupt Excel file , and errors in Excel file.

With this you can easily restore all corrupt excel file including the charts, worksheet properties cell comments, and other important data. So, this is all about the Excel slow to respond issue , follow the given steps to optimize the Excel performance. Disclaimer: This is a user generated content for MyStory, a YourStory initiative to enable its community to contribute and have their voices heard. The views and writings here reflect that of the author and not of YourStory.

Here in this article check out how to fix MS Excel slow to respond error and start working with ease. Stay Updated. Welcome Onboard! We tell your stories. Details required :. Cancel Submit. Daniel Jackson. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site.

A subscription to make the most of your time. Try one month free. Thanks for the response. Takes a few minutes just to open up or save , I am worried that once I start converting it to a table and adding formulae it's going to increase significantly. Will update my question to reflect the additional details It's 90 coloumns. So you have 4. I don't have an absolute answer on why your excel would be slow but at that size why not use an actual database for it?

Especially if you're considering adding logic on top of it. Thanks for the responses, unfortunately 64 bit Office isn't an option at the moment, but I will definitely be looking into simple database solutions — BKen. Add a comment. Active Oldest Votes. I decided to try and mimic as closely as possible your scenario. My results are as follows: 7. Unfortunately, the closest computer I could find to run this test had the following specs: Windows 7 Enterprise bit i5 2.

Improve this answer. Monomeeth Monomeeth 1, 2 2 gold badges 13 13 silver badges 22 22 bronze badges. Thank you for taking the time and effort for troubleshooting, I truly appreciate it. I tried reducing the data size by saving it to a. I'll take your advise, is there any database programs you'd recommend for database beginners? There are lots of resources to get you started and it's well worth putting the effort into.

You can even create your database by importing your current Excel data. Setop Setop 4 4 bronze badges. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.