Author Archives: fastexcel

CheckDA: Compatibility of Office 365 Dynamic Array Formulas

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? My free CheckDA tool allows you to check … Continue reading

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

Excel Summit South 2019

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 Beta 4.2

After another 6 months on my quest to create the worlds best tool for exploring, validating, debugging and editing Excel formulas I have made Explorer Pro Beta 4.2 build 418.796 available. Hopefully this will be the final Beta! The improvements … Continue reading

Posted in Calculation, Debug formulas | Tagged , , , | 6 Comments

Develop Excel Conference

The Develop Excel conference will take place in London on Thursday October the 18th 2018. It will be held at the Microsoft Reactor (70 Wilson Street London EC2A 2DB). Are you responsible for building Excel based Addins and Solutions? Develop … Continue reading

Posted in .NET, arrays, Excel, JS-API, UDF, VBA, XLL | 2 Comments

Formula Explorer Pro

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

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

Strategies for getting the last row in Excel with VBA

Using VBA to get the last row in Excel can be a surprisingly complex task. This post will explore some of the different strategies you can use. The first thing to do is to decide what you mean by “The … Continue reading

Posted in Excel, Formatting, VBA | Tagged , | 9 Comments

Excel JavaScript API Part 5: The large numbers bug

There is currently (JavaScript Excel API set 1.4) a rather nasty bug when writing large integer numbers (anything larger than int32) back to a range. 30 January 2018 – API set 1.7 – this bug is still there! The JS … Continue reading

Posted in Excel, JS-API | Tagged , | 4 Comments

Excel JavaScript API Part 4: The shallow copy problem

I was trying to read the values from a Range and then write modified versions of the values to two different ranges. Should be straightforward: Well this does not work: both B4 and B6 have 0.91 added to them: wrong … Continue reading

Posted in arrays, Excel, JS-API | Tagged , | 1 Comment

Excel JavaScript API Part 3: Benchmark of Processing Arrays Performance – Loop vs Reduce vs COUNTIFS vs VBA

In a previous post I compared several different ways of processing data with VBA. The fastest way was to get the data into a variant array and loop on it. JavaScript has some powerful array methods so I wanted to … Continue reading

Posted in arrays, JS-API, VBA | Tagged , , | 4 Comments