Why my Excel file is slow to open?

-
When I upgraded to newer version of Excel, I noticed that my Excel file take longer time than usual to open. It is not only one reason for slow performance. There are so many other reasons behind this. Let's discuss the most common problem area:

Large Calculation
If an Excel file contains large number of calculation then it will take more time in opening. So the best way is to turn off Automatic Calculation option.  To turn off this option; follow below steps:

Go to File → Options → Select Formulas → WorkBook Calculations → Select Manual.

Problem due to Add-Ins
Sometime add-ins makes your Excel file slow. So make sure you have installed the latest version of add-ins. If you have not installed Lookup Wizard add-in yet then install it now. It can make your Excel faster than before.

Hidden Objects
When you copy and paste data from various sites in to your Excel sheet then along with this data; hidden objects may pasted in your work. These hidden objects can make your workbook slow. To remove these objects; follow below steps:

Open your sheet → Press CTRL + G → Select Special → Objects → Highlight all the objects → Remove


Large Excel File
You may have seen that the size of Excel file sometime increase beyond limits and file takes forever to open. However there are many ways to reduce the Excel file size.

Keep everything at one Place
When you link your Excel sheet with other sheets, it will usually make Excel slow. So try to store all your data at one place only.

Convert Unused Formulas in to Static Value
Since lots of formulas in an Excel sheet makes it slow so you can convert unused formulas in to static value. Make sure to convert only those formulas that you don’t require in future to generate value again and again. To convert formulas in to static value, follow below step:

Click Paste special-> select value to paste.

Try to avoid Violate Functions
A violate function recalculate all the values whenever there is any change in Excel sheet and this create performance issues in Excel. So try to avoid violate functions but if you really need to use them then an efficient way is to enter the function and then reference it in your formula.

Share your comments: I am sure, there are many more issues that make Excel slow but these are the most common. If you know about any other issue then please do share.

Comments

Post a Comment

Popular posts from this blog

How to Fix Issues with Excel File Save

-
Sometimes users face problem in saving Microsoft Excel files. Excel shows different type of error messages while saving the file such as “Errors were detected while saving C:/Users/Filename.xlsx”, “an error message indicating the document was not saved or that someone else is using the file and can’t be saved”. You may face these types of issue while saving Microsoft Excel files if one or more of the following conditions are true. You have limited permissions to a network drive and you are trying to save an Excel file there. You do not have sufficient drive space and trying to save an Excel file to that location. While saving the Excel file, you have lost the connection to the file. Antivirus software program arise conflicts with the Excel file save. You are trying to save a shared Excel file. The path length for the Excel file exceeded than 218-characters. Excel file is damaged or some data in the file is corrupt. Here are some methods to troubleshoot Excel saving prob...
Read more

Ways to prevent corruption in FileMaker database

-
Image
Corruption in any type of database is impossible to avoid completely, even most secure and safest relational database like FileMaker Pro also got corrupt sometime. However you can still avoid corruption in FileMaker Pro to a certain limit, if you take necessary precautions. So let's first understand why FileMaker Pro got corrupt at first place. Reasons of corruption in FileMaker Pro: Since FileMaker is disk based application, so it just transfer the data as needed in main memory instead of loading the entire database. When it transfer data from main memory to hard disk and you unexpectedly quit the application then it is most likely that your FileMaker database becomes corrupt.
Read more

How to resolve Excel error “MS Office Excel is waiting for another application to complete an OLE action"

-
Image
It is not uncommon to receive error messages in Excel. Sometime these error messages are so strange and weird that it becomes very difficult to understand them. Today I will talk about one such error in Excel. “MS Office Excel is waiting for another application to complete an OLE action.” The above error may occur when you try to open your Excel sheet. There are three main reasons for the occurrence of this error: This error may occur when you use 'Send as Attachment' option of Excel to send the Excel sheet as an email attachment. If Excel is trying to access data from an active application. You have added too many add-ins in your application.
Read more