<div>
The GVXkeeping37DEV.xlsx file opens fine for me in Excel 2010 and Formulas-&gt;Errir checking finds no error so I think it's your Excel environment. Try things like quitting and reopening Excel and/or rebooting.
</div>


<div>
Done those.<br>Will try another machine.
</div>


<div>
Crashes out on that too. <br>Also tried loading from local drive instead of OneDrive.<br>Will try Windows 10
</div>


<div>
ok so that required a complete office install, native not parallels. Win 10 . File crashed on attempted sort, so that's three very different machines and installs. doesn't sound like the environment to me, I think it's the file.<br>Any ideas can such files be fixed?<br><br>Anthony
</div>


2021-06-02_08-27-58.png

Owner

Anthony Mellor

<div>
yes but I can't find it... which seems odd, I will have another look based on your image, thanks
</div>


<div>
The missing info was as follows (why I did not at first find the repair feature), these words made the difference"<strong><em>and click Browse." &nbsp;Only then does the repair option appear.</em></strong><br><br><blockquote>Repair a corrupted workbook manually<br>On the File tab, click Open.<br>In Excel 2013 or Excel 2016, click on the location where the spreadsheet is located, <strong><em>and click Browse.</em></strong><br>In the Open dialog box, select the corrupted workbook that you want to open.<br>Click the arrow next to the Open button, and then click Open and Repair.<br>Do one of the following:<br>To recover as much of the workbook data as possible, click Repair.<br>To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.</blockquote>
</div>


<div>
I later discovered the cause of these constant crashes-after-sort appears to be a complex LAMBDA .<br><br><a href="https://www.experts-exchange.com/questions/29217443/Rewrite-this-as-a-NON-Lambda-formula-or-just-simplify-to-solve-file-crashing-8192-error.html" rel="ugc">https://www.experts-exchange.com/questions/29217443/Rewrite-this-as-a-NON-Lambda-formula-or-just-simplify-to-solve-file-crashing-8192-error.html</a><br><br>Anthony
</div>


<div>
<div class="content wysiwyg-content fr-view">
I have searched and removed all errors using ^F .<br>Searched for these errors:<br>&nbsp;<table><tbody><tr><td>Name Error ( #NAME? )</td></tr><tr><td>Value Error&nbsp;( #VALUE! ) ...</td></tr><tr><td>Division Error&nbsp;( #DIV? ...</td></tr><tr><td>Null Error&nbsp;( #NULL! ) ...</td></tr><tr><td>#REF!</td></tr></tbody></table><br>This nearly always happens after using SORT from Auto-Filter, which this is.<br>This has been plaguing me for some weeks so finally I have surrendered and write to ask for any ideas please?<br><br>In the DATA sheet<br>The attached file crashes out upon opening.<br>&lt;file removed&gt;<br>and this one does not, it was xlsb and I renamed it xlsx<br>&lt;file removed&gt;<br>but it crashes on attempt to sort on column A.<br><br>I remain perplexed.<br>Mac Beta Channel ; hence my extended patience.<br>The problem appeared to stop when I removed a series of getpivotdata #REF! errors while solving a different problem.<br>Anthony
</div>
</div>



I have searched and removed all errors using ^F .
Searched for these errors:
 
Name Error ( #NAME? )
Value Error ( #VALUE! ) ...
Division Error ( #DIV? ...
Null Error ( #NULL! ) ...
#REF!
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.
<file removed>
and this one does not, it was xlsb and I renamed it xlsx
<file removed>
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.
Anthony

Excel crashes next sort or save action after sort in table.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.