Fix Excel 2016 Macro Running Slowly Due to an Add-In
Question details
A VBA macro executes significantly slower in Excel 2016 on a specific computer compared to others, often caused by active add-ins like EuroTOOLS.
- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Running a VBA macro that updates worksheets, expecting consistent performance across different computers.
- Observed behavior
- The macro runs very slowly because background add-ins process every worksheet change during execution.
Before modifying your macro code or disabling add-ins, note down your current add-in configuration so you can restore it if necessary.
Disable the EuroTOOLS or Problematic Add-Ins
Turning off unnecessary add-ins prevents them from intercepting worksheet changes and slowing down your macro execution.
Add-ins like EuroTOOLS monitor worksheet events in the background. If your macro makes thousands of cell changes, the add-in tries to process each one, causing severe performance drops.
Click on 'File' in the Excel ribbon and select 'Options' from the bottom of the menu.
Select the 'Add-Ins' tab from the left sidebar to view all active and inactive application add-ins.
At the bottom of the window, ensure 'Excel Add-ins' is selected in the Manage drop-down list and click 'Go'.
Uncheck the box next to 'Euro Currency Tools' (or any other suspected add-in) and click 'OK' to apply the changes.
Optimize VBA Code for Performance
Temporarily turning off screen updating, calculation, and events via VBA speeds up macro execution by ignoring background processes.
Switch to WPS Office for a Seamless and Fast Experience
If you continue experiencing performance issues and bloated add-ins in Microsoft Excel, consider trying WPS Office. It provides a lightweight, highly compatible alternative with robust spreadsheet capabilities without the unnecessary background clutter that slows down macro execution.
Frequently Asked Questions
Why does my Excel macro run fast on one PC but slow on another?
Performance differences across PCs are often due to different installed add-ins, varying hardware resources, or different Excel settings. Add-ins like EuroTOOLS can intercept worksheet events, causing significant slowdowns on computers where they are active.
Will disabling events stop my macro from working?
Disabling events (Application.EnableEvents = False) stops Excel from triggering worksheet and workbook event handlers during your macro's execution. Your macro will still run, often much faster, but you must re-enable events before the macro finishes.
How do I know which add-in is slowing down Excel?
You can identify the culprit by disabling all add-ins via File > Options > Add-Ins. Run your macro, and if performance improves, re-enable the add-ins one by one, testing the macro after each step to find out which one causes the performance drop.
