Knowledge base KB0041

Excel is slow with think-cell data links

Problem

When an Excel file contains many Excel data links it might start to scroll very slowly, taking very long to update and feeling very unresponsive. When opening the Task Manager, you can possibly observe that Excel takes up most of the CPU time.

Excel includes a mechanism that notifies the user of possible error causes in a worksheet. The automatic error checking mechanism causes Excel to update all Excel data links whenever a single cell is marked as containing an error.

Solution

Disable the automatic error checking mechanism in Excel:

  1. Open the Excel options: FileOptions
  2. FormulasError Checking → uncheck Enable background error checking

Share