Is there a way to cut down the calculating time in a workbook?

[clickclick]

I have an spreadsheet that has multiple formulas/VBA Applications/data (3 sheets with over 7000 rows of data on each, each row has 2 columns of formulas)

Whenever I do anything (sort, filter, copy, paste) it takes forever because it recalculates all the formulas. Gives me this --- Calculating: (2 processor (s)): ------

is there anything i can do so that it doesn't recalculate all the time (other than changing the calculation option to manual)?

Any advice would be appreciated.

[Pepe Le Mokko]

Wild guess : get rid of volatile functions if possible http://www.decisionmodels.com/calcsecretsi.htm) - Replace VLOOKUP with INDEX/MATCH - Get rid of merged cells used in formulas - Eliminate redundant functions ( like =SUM(a1+B1)) if any

As for other possibilities a sample sheet might help

[FDibbins]

Also, check for any unnecessary conditional formatting, and avoid formulas that use entire rows and/or columns - restrict these to the smallest range needed

[clickclick]

Basically- in the attached workbook columns B, C & D on each sheet are imported from a different source and can contain up to 10,000 rows of data. (these are imported and change daily).

I have attached a copy but cut it down to only 14 lines because the fle was too big.test.xlsm

[FDibbins]

with that many rows, this may help. Instead of using the array formulas...
{=IF(ISERROR(MATCH($C2&$D2,GL!$C$2:$C$14&GL!$D$2:$D$14,0)),"NoMatch","Match")},
add a helper column on GL to combine C & D, and then reference the helper with this regular formula
=IF(ISERROR(MATCH($C2&$D2,GL!$I$2:$I$14,0)),"NoMatch","Match")
Do the same on the other sheet