You can't use ScreenUpdating but there is a work around if you hide your "reporting" sheet. You can find the solution here: Equivalent of “ScreenUpdating” in Google Apps Script (equivalent VBA-GAS )