Macro to trigger calculations // File too slow

[Honeypum]

Hi All,

I have a huge file (4.8mb and growing) that we use to track time.

Each week of the year has a tab plus there are some "master tab" with project codes.

Finally, there are 2 summary worksheets: the goal of this spreadsheets is to compile time per project per week.

The following array formula is used:

=+SUM(IF(INDIRECT("'"&E$6&"'!a11:a100")=$C8,INDIRECT("'"&E$6&"'!N11:N100"),""))

The issue I'm having is that each time someone inputs time in their weekly time sheet, the file becomes very slow because the so called summary worksheets are refreshing the calculations.

Is there any marco I can use to stop this summary worksheets from "re-calculating" and make it a manual process?

Thanks in advance for your help!

[Sadath31]

set your calculation mode into Manual (tools>Option calculation tab)
then copy to sheet code (which are the sheet you want to calculate automatically,)

Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Calculate
End Sub