Is there a way to make excel stop calculating a formula when it is taking an
excessive amount of time? i.e. when running certain pivot tables, if the
data is not sorted properly it will take several minutes to run a summary. I
would like to be able to stop the calculation, sort and rerun the report.

Thanks