Author Archives: fastexcel

Why Structured References are slow in Excel 2013 but fast in Excel 2016

Tables have a bad reputation for performance. Zack (Firefytr) Barresse (who wrote the definitive guide to Excel Tables with Kevin (Zorvek) Jones) recommends a limit of around 10K rows for tables if you want to keep performance reasonable. Prompted by … Continue reading

Posted in Calculation | Tagged , , , , , | 5 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 | 8 Comments

Excel Memory Checking Tool: Using LAA to increase useable Excel memory

Most of us sooner or later get hit by one or more of the dreaded messages “Out of Memory” or “Excel cannot complete this task with available resources” or “Not enough System Resources/Memory to Display Completely” , regardless of how … Continue reading

Posted in Memory, VBA | Tagged , , , , | 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

Writing Efficient VBA UDFs Part 15: Adding Intellisense to your UDFs

For several years people have been asking the Excel Dev team to add the capability to create Intellisense for UDFs to work the same way as native Excel functions. Well, now Govert van Drimmelen, author of the wonderful Excel DNA, … Continue reading

Posted in .NET, UDF, VBA, XLL | Tagged , , , , | 10 Comments

Writing Efficient VBA UDFs Part 14: Handling whole columns using Implicit Intersection – Updated

Excel has an interesting and very efficient trick called Implicit Intersection which allows you to use large Named Ranges and whole column references efficiently. What is Implicit Intersection? When Excel expects to get a single cell reference but you give … Continue reading

Posted in arrays, Calculation, UDF, VBA, XLL | Tagged , , , , | 9 Comments

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 | 5 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 | 14 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