Forum Discussion
Excel - Long Lag on Data Entry
195 MB is a huge size for an Excel file. What's the reason of this?
If you have only 50 cells for data entry on first sheet, what's there on other 6 Sheets?
Are you having some formulas on other sheets which involve some kind of cell comparison or formulas which refers to whole columns or rows?
Maybe it's time for you to revise those formulas. If formulas are complex, make some helper columns and simplify the formulas.
Also, select each sheet and press Ctrl+End to detect the last cell used and if you find that irrelevant, delete the unused blank rows and columns.
Make sure that you have not copied down the formulas to large number of rows.
You may also consider saving your file as binary file .xlsb to reduce the file size.
Hi Subodh_Tiwari_sktneer, You have a 195 MB huge size Excel file and you don't know the reason of this. You have done most of the things to optimize the file for making calculations work faster but still it is slow.
Recently, I faced similar problem with an excel file in which used to enter data & perform calculation on daily basis and one day it was taking more time in calculations, switching to sheets and while opening & closing.
After perusing the data I found that by mistake some one pasted the several images of a cell instead of copy paste of value from one cell to another. The data entry guy who just copied the value from a cell & pasted a image to below cell. Later on again he copied the data from pasted cell and this time he copied that pasted image also and again pasted in the cell below to it. This action was done many a times and due to this i was having several images in my excel file. This resulted in slow processing the file.
I identified those images & replaced with data into the cells and issue was fixed.