Excel Not Responding - Action Too Large

Hello Jo,

Thank you for your question. Below are a few issues that cause Excel to be slow or to run out of memory:

1. Excessive cell formatting or styles - check and clear any excessive unnecessary formatting.

2. Large numbers of shapes and images - these increase file size, delete if unnecessary

3. Conditional formatting - check and delete, leave only if critical to the data

4. Formulas which slow down Excel:
Vlookup, Indirect, Offset
Remove unnecessary formulas, replace Vlookup with Index and
Match or Xlookup.

5. Too many filters running on large data. Copy and paste filter
results and clear filters.

6. Delete empty rows and columns - they may contain hidden
formatting or hidden remnants of deleted data.

I hope this helps.

Kind regards
Marius Barnard
STL