Excel runs on the local PC for best performance. At the same time Excel writes each changed cell to the PC storage device. For big data sets this can be a problem. The Excel Specialist remedies this by: read the data to memory, process the data and write to storage once. This gives an enormous performance advantage. It is making use of the fact memory is much faster then storage (=disk or SSD).