2 min read

Speed up DataLink Excel with Asset Framework

The InCentrik Team Apr 20, 2022 8:35:51 AM

Excel

It's common in many industries to have issues with Excel workbooks slowing down when working with PI, but you don't have to settle for the delay.

There are ways to turn your slow Excel experience with DataLink into something manageable, so you can stay on top of operational efficiency.

When common tasks take a long time with Excel, it's far less likely to be modified to have more data for fear that this will prolong the process even more.

Solutions to Improve Slow Excel

Skylabs provides solutions to working with Excel DataLink files and resolves speed issues using our best practices checklist.

We have an extensive history of solving these problems for a variety of situations, as well as training on Excel DataLink and Asset Framework.

Our best practices are broken into three groups:

1. DataLink Best Practices

There are specific recommendations on how to set up DataLink within Excel that ensure DataLink is run only when necessary and isn’t querying every time “Calculation” is called.

2. Offloading Slow Calculations to AF

By identifying slow steps within the Excel file, we can then offload that into asset framework. Asset Framework is run 24/7 and can save results.

3. Excel Best Practices

There are some common issues that cause Excel to become slow that are unrelated to DataLink. These should also be checked.

Why Excel Speed Matters

It's important to stay ahead of the curve when it comes to optimizing the tools you need for your operations, which translates to increased revenue via boosted efficiency and production output. Overall, it comes down to making the absolute most of you and your team's time and energy.

Prevent Wasted Time

If Excel is trying to run a process or report, and it slows down, it may take up to 4 times as long to accomplish it's task than it would otherwise. Oftentimes, these types of slowdowns also prevents other Excel files from working properly, as well.

All the time that is spent waiting for Excel to respond adds up to a sum of lost productivity.

Enable Improvements

Outside of taking away from baseline productivity, slow Excel files can deter anyone from trying to make improvements.

Even if parts of meetings are spent brainstorming ways to improve the report, people may become unwilling to add new tags to the report because they believe it will slow Excel even further, or maybe compromises were made on the frequency or date range of data.

When this happens, the entire team's time is wasted and the effort is ineffective.

Identify Problems Sooner

Since these problems with Excel are common, some processes are built to work around this, specifically designed to accommodate slow Excel files.

While this may seem like a logical solution to a problem, it prolongs the inevitability of finding a problem which also prolongs the solution, and since nobody will want to slow Excel any further, team engagement may also suffer.