Excel very slow

[Formula11]

I have a worksheet (Sheet1) with thousands of rows, 150 columns and most cells have formulas.
Formulas reference another worksheet (Sheet2) for input. When I try to add a row for example in Sheet2, Excel freezes for up to 10 minutes until cells are updated I presume.

Looked at reasons why from web pages below.

Believe that one of the main reasons is because there is more than one worksheet. Is there a way to fix the issue, without placing contents of Sheet2 into Sheet1 as this is not really practical. Manual calculation helps but still slow.

Excel performance - Improving calculation performance
10 Tricks to Fix Slow Excel Spreadsheets (Speed-up Excel)

 

[RustamMika]

Hi,
I prefer to use VBA instead of formulas...

 

[bebo021999]

It depend on what kind of formula you have
SUM, COUNT,VLOOKUP,...: no problem
but
SUMIF,COUNTIF,... or ARRAY FORMULA: so heavy and slow down PC

Could you share your formula here?

 

[Alex Blakenburg]

You can add Conditional Formatting over thousands of rows to your list as a performance killer as well.

 

[Formula11]

Thanks for responding.

For formulas, typical type include:

=IF(OR(AND(E5642>=202,E5642<=204),AND(E5642>=252,E5642<=253),AND(E5642>=302,E5642<=304),AND(E5642>=352,E5642<=353)),"One",IF(OR(AND(E5642>=205,E5642<=205),AND(E5642>=254,E5642<=256),AND(E5642>=305,E5642<=305),AND(E5642>=354,E5642<=356)),"Two",IF(OR(AND(E5642>=201,E5642<=201),AND(E5642>=206,E5642<=211),AND(E5642>=251,E5642<=251),AND(E5642>=257,E5642<=260),AND(E5642>=301,E5642<=301),AND(E5642>=306,E5642<=311),AND(E5642>=351,E5642<=351),AND(E5642>=357,E5642<=360)),"Three")))

=IF(SUMPRODUCT(--(E5642={"Hold"}))>0,"One",IF(SUMPRODUCT(--(E5642={202,203,204,205,252,253,254,255,256,302,303,304,305,352,353,354,355,356}))>0,"Two",IF(SUMPRODUCT(--(E5642={201,206,207,208,209,210,211,251,257,258,259,260,301,306,307,308,309,310,311,351,357,358,359,360}))>0,"Three")))

I also did have a conditional format rule, removed that and it only takes 5 to 10 seconds now, so this is OK I think and is manageable.
But it's strange as conditional format was in main Sheet1, and editing in input Sheet2 was the issue. Editing in main Sheet1 was not so much an issue.

Thanks for assistance.

 

[Alex Blakenburg]

You're welcome. Glad we could help.
PS: Conditional formatting is effectively volatile. I am only guessing her but I suspect that since Sheet1 is dependent on Sheet2 that changes to Sheet2 have a greater than recalculation impact on Sheet1 then making changes on Sheet