N/APosted on - 01/29/2013
I am currently into a data entry job. To prevent duplicates, I have placed a formula that would indicate to me if there is a duplicate. My problem is that, when I reach thousands of data my excel file tends to slow down. Can you teach me how to speed up my excel file. Thanks in advance
How to speed up my excel file, need help with this
Simple things on how to speed up your excel
1. Avoid all recorder that's pop-out automatically
Range("A1").Copy** this is the example that a simple spreadsheet will give you when you're working.
2. Shut down Calculation and other screen updates
Furthermore, It would be best If you reboot your PC so that you will have enough RAM to run a program.
Hope this works