I have a large (5000 row by 45 columns) list I import from as a csv from another software package. It contains reasons that are not always accurate, so I filter by reasons and review comments in another column to correct the reason. Quite often when I do this, Excel will stop and either crash completely or restart with a recovered file. I cannot use find and replace as sometimes the reason is correct. Is this normal behavior for Excel??
Excel crashes when editing a filtered list
1.8k Views Asked by John Finley At
1
There are 1 best solutions below
Related Questions in EXCEL-2013
- Copy Only Filtered Data From Table Using VBA
- Font.Italic property not working in Excel 2013
- Remove blank rows from a column
- Ideas how to Pivot in Excel 2013
- Required Brand wise data in excel
- Need Help in Excel formula - Product wise large to small
- Unable to Put the Count Formula linked with count of next column details
- Copy a formula in Excel from one worksheet to another and have worksheet name in formula update
- Excel: in 2 page view, horizontal scrolling disabled
- In excel, how do i hide duplicate value of Column A & B (where AB=BA)
- How to lookup and return multiple values alternating (50/50)
- How can i split a column in more columns based on a specific value in certain cells
- Range variable setting empty value
- VBA executes slowly if there are blank cells
- Search with a single TextBox that will filter every column in a table?
Related Questions in FILTERED-INDEX
- Why is this combined SORTYBY,FILTER,SEQUENCE,INDEX,COUNTIF formula sorting partially?
- sys.dm_db_index_usage_stats doesn't work fine with filtered indexes
- How can I get the index of a localstorage array and use it with a filtered array?
- Liquibase Code generated for a conditional index gives error in MS SQL Server
- Create unique filtered index on a table with complex conditions in SQL Server using Triggers
- Filtered indexes and updates
- Excel: How to create filtered list using formula by criteria containing asterisks
- Subquery in the WHERE clause in Nonclustered Filtered Index
- Why must quoted_identifier be ON to use a filtered index?
- Table and Index Partitioning & Filtered Index in SQL Server 2016 SP1
- What does filtered mean in the context of MySQL EXPLAIN EXTENDED?
- Entity Framework query missing a filtered index on SQL Server 2012
- Why a coverage filtered index do a Lookup
- Filtered Index in SQL Server missing predicate does not work as expected
- Filtered Unique Index causing UPDATE to fail because incorrect 'QUOTED_IDENTIFIER' settings
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
No, this is not the expected behavior for Microsoft Excel, I work with huge databases and have not seen this happening. I would suggest you look into your computer specs, specially memory. Can it handle that amount of information? Best of luck.