AnsweredAssumed Answered

How does Datalink data transfer figure into the "Calculating" Excel toolbar indicator?While working from home for COVID-19, I notice that the calculations take much longer over VPN remote access.

Question asked by cjrancur on Mar 31, 2020
Latest reply on Aug 4, 2020 by cjrancur

While working from home using remote VPN during the COVID-19 pandemic, I have noticed that this "Calculating" indicator at lower right within Excel 2010 takes much longer to finish whenever I pull data and also use calculations while working remotely.  Does Excel just use the word "Calculating" when it really means processing, which includes both network data transfers and calculations? Is there any way to find out what proportion of the "Calculating" time is PI data retrieval within Datalink formulas, and what proportion is running non-Datalink formulas within Excel?