Category Archives: Uncategorized

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

2016 Microsoft MVP Summit, Part 2: Trump Wins

Posted on November 20, 2016 by fastexcel

Tuesday November 8 I was in Redmond at the Microsoft MVP Summit. It was also the day of the USA presidential election. This was my flashbulb moment, observed from a European perspective: A small group of us Excel MVPs (Roger … Continue reading →

Posted in Uncategorized | 1 Comment

2016 Microsoft MVP Summit, Part 1

Posted on November 20, 2016 by fastexcel

I was privileged to attend the 2016 Microsoft MVP Summit in Redmond November 6-10 along with many other Excel MVPs. We had some great sessions with the Excel and the Office Extensibility Product teams, and I have to say that … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment