I run an SPC chart with a power query created table that tests results against Nelson Rules. The samples runs fairly quickly, so I have the Refresh every set to 2 minutes during the day.
The refresh triggers a Worksheet_Change event that checks the timestamp of the most recent run, to the...