I have searched and removed all errors using ^F .
Searched for these errors:
This nearly always happens after using SORT from Auto-Filter, which this is.
This has been plaguing me for some weeks so finally I have surrendered and write to ask for any ideas please?
In the DATA sheet
The attached file crashes out upon opening.
and this one does not, it was xlsb and I renamed it xlsx
but it crashes on attempt to sort on column A.
I remain perplexed.
Mac Beta Channel ; hence my extended patience.
The problem appeared to stop when I removed a series of getpivotdata #REF! errors while solving a different problem.