Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Newsletter

My newsletter archive

August 2019: Combinations, Combinations (2), a challenge

May 2019: All combinations between of two (or more) lists

February 2019: Something I don't like about PowerQuery (Locale)

November 2018: RefTreeAnalyser license and updates

October 2018 (2): Excel VBA Masterclass anouncement

October 2018: Updates to some important free Excel tools and why I did them

September 2018 Topics: Catching and acting upon a compile error in your add-in

July 2018 Topics: What I've been up to in the past months.

February 2018 Topics: Ignore blanks on Datavalidation, what does that mean?

December 2017 Topics: Inconsistent Calculated Column Formula

October 2017 Topics: End User Computing (EUC)

September 2017 Topics: Selecting cells which do not belong to a set of ereas

July 2017 Topics: A short history of Name Manager and a poll about a feature we are about to remove

June 2017 Topics: Co-Authoring has an unexpected side-effect

May 2017 Topics: Report of The Amsterdam Excel Summit

April 2017 Topics: Fixing display problems with Excel 2010 on Windows 10

March 2017 Topics: Updates to RefTreeAnalyser, Amsterdam Excel Summit program

February 2017 Topics: Getting selected slicer items into your spreadsheet cells

January 2017 Topics: Bug in Styles object (VBA)

November 2016 Topics: Form controls bug revisited; What to use, Integer or Long?

October 2016 Topics: Form controls bug; report about Excel VBA Masterclass

September 2016 Topics: Excel Wheel Of Fortune, MVP Award

July/August 2016 Topics: Problems opening downloaded Excel files

June 2016 Topics: Problems with the ABAP2XLSX library

May 2016 Topics: Report of the Amsterdam Excel Summit 2016

April 2016 Topics: Update to RefTreeAnalyser

March 2016 Topics: Prevent deleting a sheet

February 2016 Topics: A Moving Checkbox

January 2016 Topics: Table Of Content, Webservice demo

December 2015 Topics: Useful VBA routines

November 2015 Topics: Articles on my website pertaining to Excel add-in development

October 2015 Topics: A faster model by getting rid of VLOOKUP

September 2015 Topics: Celebrating the 30th anniversary of Excel!

August 2015 Topics: Tools for Excel and VBA everyone should own.

July 2015 Topics: Golden rules for developing spreadsheets.

June 2015 Topics: Using the function wizard on nested functions, Summer sale, upcoming courses

May 2015 Topics: Use hyperlinks and Goto to find your VBA code, Why is my worksheet dead-slow.

April 2015 Topics: Date and time shortcut, Slow responding worksheets, Declare variables in VBA, Amsterdam Excel Summit, course "Excel VBA voor financials"

March 2015 Topics: Formula auditing shortcut, Styles, Amsterdam Excel Summit