Poor performance when triggered by event but fast when hitting F5

Attached is a project I was helping another member on [stusic=macros to automatically update form=212185-BOM.xlsm]. I have added VBA to create a list based on a BOM worksheet. Results are in worksheet List. It is triggered by a change on worksheet BOM via Worksheet_Change. When it runs from the event, it takes around 90 seconds to run. But if I hit F5 in the VBA development window, it takes less than 1 second.

It does not make any changes to the BOM worksheet, therefore will not trigger any recursive calls to Worksheet_Change.

What can possibly be different about those two modes of invocation that would cause such a disparity in performance?

It takes about 1 second for me to run for both methods.

I say restart your PC and try again.