Category Archives: Uncategorized

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

Excel JavaScript API Part 1: Overview & Comparison

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 , , , , | 8 Comments

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

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

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

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

Excel: Evil and Hero Functions

Some time back I setup a (not too serious) survey (based on Excel online of course) to see what people thought were the best (most heroic) and worst (most evil) Excel worksheet functions. And the most evil function is: GETPIVOTDATA! … Continue reading

Posted in Uncategorized | 8 Comments

INDIRECT – Excel’s Most Evil Function

My choice for Excel’s most evil worksheet function is INDIRECT, for reasons outlined below. If you have a different choice you can cast your vote for your most evil function (and your favourite function) here. So what makes INDIRECT so … Continue reading

Posted in Uncategorized | 27 Comments

Special Offer for Excel Summit South

If you were thinking about joining us at Excel Summit South for what promises to be a great 2 days of Excel then register now to take advantage of a 10% discount offer. Just use coupon code LIMITED – the … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment

2015 in review

The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog. Here’s an excerpt: The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 170,000 times in 2015. If it were an exhibit at … Continue reading

Posted in Uncategorized | Leave a comment