WebMar 1, 2024 · Excel crash trying to sort large data file. I have a file that has 30,000 rows, no forumulas in the data just names and addresses. I use conditional formating to highlight duplicates on ID and post code. When i click on data sort to sort by cell colour it just seems to crash all the time. I have tried to copy to new workbook and also to format ... WebDec 15, 2024 · Aug 5, 2024. #2. If the file contains a lot (hundreds thousands lines) of data, those bugs can happen. It can also happen if a macro is linked to the clear all filters …
Excel crashing (only on one user profile) - The Spiceworks Community
WebNov 25, 2024 · @Riny_van_Eekelen It works fine if I sort A-Z after removing the CF.But I need to sort after using conditional formatting to highlight duplicates.. Other solutions … WebJan 6, 2024 · Excel crash when applying a filter. Sign in to OneDrive.com. Click ? help icon located at the top, select Email OneDrive support. Submit your concern. Follow the prompts to request support. bulova phantom pocket watch
Excel Window Freezes after Clearing All Filters
WebNov 29, 2024 · Re: Excel 2013 Crashes When Clearing Filters. This is still an issue in Excel 2013. Even a fairly small, single sheet workbook with minor calculations may freeze if conditional formatting is active, and you use the "Clear Filter" button even if you only had simple filtering on one column. I have one with a single conditional formatting rule ... WebApr 6, 2024 · 8-10 seconds! Excel does enter “Not Responding” (freezing) mode for a few seconds too, which is always scary. It may be faster or slower on your computer, but this is a very simple data set with no … WebMar 29, 2024 · Click ' Yes ' when a prompt appears to confirm. Alternatively, press Windows+R, type excel /safe and press ' Enter '. Use this to open Excel in safe mode on Windows 10, 8.1, 8, or 7 system. Now try to open and access the Excel file and check if the issue is resolved. If it's not, head on to the next solution. bulova pink face women\u0027s watch