LibreOffice Calc Slow or Not Responding on Large Files

How to fix it

// try these in order, the most common fix is first

1. FIX 1Toggle Skia

   Copy steps
   1. 01Tools > Options > LibreOffice > View
   2. 02Untick Use Skia for all rendering or force software rendering
   3. 03Restart
   Did this fix it? Yes No

2. FIX 2Enable OpenCL for heavy formulas

   Copy steps
   1. 01Tools > Options > LibreOffice Calc > Calculate
   2. 02Tick Enable OpenCL only if you run large calculations
   Did this fix it? Yes No

3. FIX 3Reduce load

   Copy steps
   1. 01Switch to manual recalculation (Data > Calculate)
   2. 02Trim whitespace and large cell text
   3. 03Split the workbook into smaller files
   Did this fix it? Yes No

4. FIX 4Update

   1. 01Install the newest release, since several slow-open bugs were fixed between versions
   Did this fix it? Yes No

Symptoms

Calc lags when scrolling, takes minutes to save or freezes with 'not responding'.

Why it happens

• C-01Very large cell content
• C-02Many sheets or volatile formulas
• C-03Skia or OpenGL driver issues
• C-04Old LibreOffice version

// this guide also covers

• libreoffice calc slow
• libreoffice calc not responding
• libreoffice calc freezing

The same problem in other apps

All crashes, freezes & blank screens guides →

• PowerPoint Not Responding or Freezing (Microsoft PowerPoint)
• Keynote Not Opening or Crashing on Mac (Apple Keynote)

Other LibreOffice errors

• LibreOffice Won't Open or Crashes on Startup
• LibreOffice Messes Up Word DOCX Formatting
• LibreOffice Impress PPTX Animations and Fonts Not Working
• LibreOffice Calc VBA Macros Not Working
• Why Is LibreOffice So Slow to Start?
• LibreOffice Document Could Not Be Locked Error
• LibreOffice Crashing or Not Opening on Mac
• How to Recover an Unsaved or Corrupt LibreOffice Document