Editing Troubleshooting of common Excel errors (section)

=== Excel Performance Issues ===
* Alternative solutions when dealing with large datasets
** When Excel data contains approximately one million records, operations may take several hours. Consider using a database instead. Process data in the database first, then export to Excel format, rather than performing data processing or calculations directly in Excel.
** When deleting approximately 10,000 rows that meet specific criteria is too slow, filter for rows that meet different criteria, then copy and paste to a new worksheet - this will be faster. If direct copy-paste also takes more than 5 minutes, choose to paste values only. Related article: [https://errerrors.blogspot.com/2020/03/resolve-too-slow-to-delete-data-rows-in-excel.html Resolve too slow to delete data rows in Excel]
* Reducing data processing complexity
** Select all worksheet cell data, copy, then paste special values to a blank worksheet. Removing formulas will speed up operations on the new worksheet. {{exclaim}} Note that time format values may be corrupted and become long strings of numbers, requiring additional cell formatting to time format.
** Multiple filter criteria consume more system resources. Instead of using filter criteria, using functions for processing will be faster.
* Computer performance
** Upgrading software from 32-bit to 64-bit version enables more efficient memory usage. e.g. [https://support.office.com/en-us/article/Choose-between-the-64-bit-or-32-bit-version-of-Office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261 Choose between the 64-bit or 32-bit version of Office - Office Support]
** Close unused Excel files to conserve computer performance
* Switching to different software
** First use [https://zh-tw.libreoffice.org/discover/calc/ LibreOffice Calc] to operate ODS ([https://en.wikipedia.org/wiki/OpenDocument OpenDocument] Spreadsheet) or Excel XML file formats, which process faster. Then export to Excel file format.