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

think-cell uses cookies to improve the functionality, performance and security of this site. Your consent is necessary if you want to use the full functionality of this site. More information on the use of cookies by think-cell, your consent and your privacy rights can be found in our privacy policy.