How to speed up my excel file, need help with this

Asked By 0 points N/A Posted on -
qa-featured

Hi guys,

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

SHARE
Answered By 0 points N/A #156271

How to speed up my excel file, need help with this

qa-featured

Simple things on how to speed up your excel

1. Avoid all recorder that's pop-out automatically

change to:
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

Steele Ney

Related Questions