logo ASAP Utilities

Answered Questions (FAQ)

If you have a question or experience a problem with ASAP Utilities then please verify if there is already an answer to your question or solution for you problem in our list of frequently answered questions.

Upgrading

How to upgrade to the latest version of ASAP Utilities.

Possible causes of slower performance and how to solve it

Date: November 8, 2018 (last updated on November 2, 2020)
reference id: QA0310

Introduction

Unfortunately there are few things out of our influence that can cause the tools from running slower than expected in Excel.
Reduced speed might be related to a specific workbook that you use, the Excel version/build that you use, or something else on your system.

Bugs in certain Excel builds

Check if you have installed the latest updates from Microsoft Office 2016/2019/365?
Because there have been bugs in Excel that could impact the performance of macros/add-ins: 
The importance of Microsoft Office Update | Fix random crashes Microsoft Office Updates
Microsoft Office Updates

Workbooks with Linked Pictures

There is a strange and annoying bug in Excel that can cause macros to run very slow in a specific situation:
If one of the open files in Excel has a linked picture, then it affects all workbooks and macros (that update cells) run much slower.

More information:

Working with files from OneDrive

In case you open a file from OneDrive, macros (that update cells) can run up to 5 times slower.
Turning AutoSave on or off makes no difference, turning OneDrive desktop client on/off makes no difference, turning off "Use Office applications to sync Office files that I open" in OneDrive makes no difference, turning internet connection on/off makes no difference either, speed stays slow.
However, although we haven't found a logical explanation for this, a temporary workaround is:
1. File > Info > Manage Workbook > Check Out
2. File > Info > Check In
3. File > Info > Edit workbook
After these steps, the speed is back to normal again.

(OneDrive issue discovered with Excel 365, version 1908)

Microsoft: VBA code writes to cells slowly in worksheets with many invisible ActiveX controls

Consider the following scenario:
- You are working in Excel for Office 365, Excel 2016 or a later version.
- A worksheet contains many ActiveX controls that are set to be invisible.
- You have VBA code that writes many formulas to cells.
In this scenario, Excel writes to the cells very slowly when you run the VBA code.

# VBA code writes to cells slowly when many ActiveX controls are invisible in Excel 2016, Excel 2019 and Excel 365
https://docs.microsoft.com/en-us/office/troubleshoot/excel/vba-writes-to-cells-slowly

Microsoft: Incompatible video configuration may cause reduced performance of an Office program (other than startup and shutdown).

You may experience one or more of the following symptoms if you have a video configuration on your computer that is incompatible with the Office feature set that is responsible for displaying the application and for animations in the application.

- An Office program is blurry.
- Your screen flickers or flashes.
- An Office program is either mostly all white or all black.
- Text in your document is not displayed well.
- Your Office program crashes.
- The performance of an Office program (other than startup and shutdown) is reduced.
- In Microsoft Lync, there may be video delays or slowness when you are on a video call.

# Display issues in Office client applications
https://docs.microsoft.com/en-us/office/troubleshoot/settings/office-display-issues

Microsoft: Excel not responding, hangs, freezes or stops working

This article discusses troubleshooting steps that can help resolve the most common issues when you receive an Excel not responding error, Excel hangs or freezes when you launch it, or open an Excel workbook. These types of problems may occur for one or more of the reasons listed below.
...If your antivirus software includes integration with Excel you may experience performance issues...

# Excel not responding, hangs, freezes or stops working
https://support.microsoft.com/en-us/office/excel-not-responding-hangs-freezes-or-stops-working-37e7d3c9-9e84-40bf-a805-4ca6853a1ff4






« back


Home Privacy Policy Cookie Policy EULA Sitemap Search List of all utilities Printer friendly page Contact Us ^ Back to Top
© 1999-2021 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook