I have a mildly complex workbook with a lot of index(match) functions to other workbooks, and one particularly processor intensive index(max) array function, so I understand why it sometimes takes a minute or so to process changes on my older laptop (excel 2016). But occasionally I run ad hoc reports by filtering a sheet and copy/paste values into a temp worksheet. Rarely more than a 100 rows of 10 or so cols. Frequently, this action causes the whole workbook to update, locking the workbook up for minutes at a time. Any idea what could be causing this, or a workaround to avoid it?