Problem in Excel Sheet

[JAGDISHRAIKHINCHI]

Dear Seniors,

Greeting!!!

I make in excel four to five files and also link with each other with vlookup formulas.But now i am facing problem when I enter data in master sheet then after enter a data in column then on below bar start processor 2.when it runs then it takes too much time.Please help me to solve this problem.

Thanks & Regards
Jagdish

[alansidman]

I am guessing that your file is very large. Suggest you change calculations to Manual. Put an Icon on your QAT for calculate now. After making all your updates to your file, click on your new Icon to calculate before closing the file. This will speed up input and changes but will may still take a while to re-calculate the sheets.

[JAGDISHRAIKHINCHI]

Dear Senior,

Thanks for Nice reply

Yes this is heavy file.Could you guide me how I can make QAT.

Thanks
Jagdish

[adhawan06]

You can may be try deleting blank cells

[alansidman]

Look at this link for tutorial on QAT
https://support.office.com/en-in/art...rs=en-IN&ad=IN