Category Archives: Uncategorized

VBA Corruption Registry Fix

Posted on February 24, 2024 by fastexcel

There seem to be more cases recently where the VBA in a workbook gets corrupted and is removed when the workbook is reopened. Circumstances Nobody seems to know exactly why this happens but there there do seem to be one … Continue reading →

Posted in Uncategorized | Tagged , , | 3 Comments

Sheet Calculate Change

Posted on February 24, 2024 by fastexcel

Recent builds of Excel 365 (version 2308 onwards) have introduced a change to the way Sheet Calculate (Shift-F9) works. Previously Sheet Calculate did a recalculate of all changed and volatile cells on the selected worksheet(s), but did not marke these … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

Finding VBA Bottlenecks with VBA Profiler

Posted on October 29, 2020 by fastexcel

When you are faced with slow-running or complex VBA projects it can be very helpful to have a tool that allows you to time the individual parts of your code or trace the execution path as event-driven jumps occur. Googling … Continue reading →

Posted in Uncategorized | 1 Comment

Excel Virtually Global

Posted on July 17, 2020 by fastexcel

https://excelvirtuallyglobal.com/ Tue 21 July to Thu 23 July 2020 Microsoft’s Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the “bleeding edge” and have an unstoppable urge to get … Continue reading →

Posted in Uncategorized | Leave a comment

Backward Compatibility of Office 365 Dynamic Arrays (Updated 23 Sep 2020)

Posted on May 20, 2019 by fastexcel

Office 365 Excel Dynamic Arrays are great, but: What happens when you create a workbook with Dynamic Array  Excel (Excel DA) and send it to someone who does not have Excel DA, and how do you write VBA code that … Continue reading →

Posted in arrays, Dynamic Arrays, Excel, Uncategorized, VBA | Tagged | 21 Comments

Excel Summit South 2019

Posted on May 13, 2019 by fastexcel

If you can get to Australia in July/August check out the Excel Summit South 2019 conference. http://excelsummitsouth.com/ There is a great list of speakers and a chance to discuss Excel with a Microsoft Dev Team member and a host of … Continue reading →

Posted in Uncategorized | Leave a comment

Formula Explorer Pro

Posted on July 19, 2018 by fastexcel

I have spent most of the last 18 months or so working on a new tool to improve on Excel’s ancient Trace Precedents and Evaluate formulas tools. It is called Formula Explorer Pro, and it is part of FastExcel Manager … Continue reading →

Posted in Uncategorized | 6 Comments

Excel 2016 Performance Improvements

Posted on January 29, 2018 by fastexcel

Excel 2016 Performance Improvements The Excel team has made a number of performance improvements to Excel 2016. These improvements were rolled out as part of the Office update cycle. The timescale that updates become available to you depends on which … Continue reading →

Posted in Uncategorized | 6 Comments

Excel JavaScript API Part 1: Overview & Comparison

Posted on March 13, 2017 by fastexcel

I have been spending time in the last few months experimenting with the new JavaScript Excel API. This is the first of a planned series of posts examining the JS-API from the point of view of an Excel Office developer. … Continue reading →

Posted in .NET, JS-API, UDF, Uncategorized, VBA, XLL | Tagged , , , , | 10 Comments

Excel Versions Screen Test (Updated): how fast is Screen Updating?

Posted on December 14, 2016 by fastexcel

Gurs has an interesting benchmark he has been running on various systems and Excel versions over the years. His results seem to show a massive performance decline in later Excel versions. Looking at his benchmark and its VBA code you … Continue reading →

Posted in Calculation, Formatting, Uncategorized, VBA | 9 Comments