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

Asked By jaylonomarion 0 points N/A Posted on - 01/29/2013

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

• Status: Open
• Question Views: 939
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Steele Ney 0 points N/A #156271

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

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

About Steele Ney

Questions
3

Answers
122

Best Answers
31

• Vote Up 0 Vote Down

• Posted on - 01/31/2013
• Question Category: MS Excel