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

Bestand crasht Excel!!

Red mijn werkmap!
De beste tool voor Excel bestanden met problemen.

Cursussen

Excel VBA Masterclass (Engels)
Excel VBA voor Financials

Third party tools

Speed up your file

FastExcel
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 > Nederlandse site > Nieuws
This page in English

Wijzigingen aan deze site

De 20 meest recente wijzigingen

(In omgekeerd chronologische volgorde, zowel Engelse en Nederlandse pagina's):

Updated article: Working with Circular references in Excel
I have updated the page on VBA driven circular reference calculations
Tue, 22 Oct 2019 11:45:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. Fixed issue where references are not found when formula contains new line character (alt+enter).
Thu, 26 Sep 2019 12:15:00 GMT
And the winner is...
Today I've posted the solutions I received for my Excel challenge of August 2019 named Combinations, Combinations.
Thu, 19 Sep 2019 14:00:00 GMT
Updated: Compare Two Tables
I've enabled the Compare2Tables tool to work on 64 bit Excel.
Tue, 03 Sep 2019 14:50:00 GMT
Updated: Pivottable Slicers, Synchronizing slicers
I have added a download file to the article on how to synchronize slicers from different caches.
Thu, 29 Aug 2019 15:05:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have improved the Check Formulas interface.
Tue, 06 Aug 2019 16:19:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have fixed a small bug pertaining to hard-coded strings in formulas.
Mon, 29 Jul 2019 16:45:00 GMT
Update: CorruptFiles
I have updated my little article on corrupt Excel files.
Mon, 29 Jul 2019 16:45:00 GMT
Updated article: Keeping Userforms on top of SDI windows in Excel 2013 and up
I've just fixed a bug in the class module which caused errors when you would minimize an Excel window. Thanks to Philippus, who reported this bug.
Mon, 01 Jul 2019 09:45:00 GMT
Updated: Compare Two Tables
I've added a new feature to the Compare2Tables tool. You can now select which difference tables you want the tool to produce.
Tue, 02 Apr 2019 16:40:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have added a feature where pressing find precedents on a Pivot chart will select the underlying pivottable.
Tue, 26 Mar 2019 12:55:00 GMT
A new tool: Compare Two Tables
I've added a new tool (in beta!!) to my download section called Compare2Tables.
Mon, 25 Feb 2019 17:00:00 GMT
Update: Name Manager
Name Manager has just been updated to build 666. Name Manager will now recognize names starting with _xlfn as Excel system names.
Tue, 22 Jan 2019 13:50:00 GMT
Updated : Flexfind
Flexfind has been updated with a small number of improvements: better search in chart items and better grouping of cells with identical formulas.
Wed, 16 Jan 2019 07:50:00 GMT
Updated : Table Tools
I updated the TableTools add-in, with a couple of bug fixes.
Mon, 12 Nov 2018 15:15:00 GMT
Updated : Table Tools
I updated the TableTools add-in, which now ensures name changes of Tables are updated in PowerQuery queries!
Fri, 09 Nov 2018 08:30:00 GMT
The Excel VBA Masterclass
I'm scheduling a new run of my Excel VBA Masterclass soon. Make sure you enter our Survey if you're interested
Wed, 31 Oct 2018 13:45:00 GMT
Update: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have fixed a bug regarding getting references from chart series.
Wed, 31 Oct 2018 13:45:00 GMT
The Ljubljana Excel VBA Masterclass
Come and join me in Ljubljana November 5th, 2018 for The Ljubljana Excel VBA Masterclass. Make sure you Visit the Website
Mon, 1 Oct 2018 15:55:00 GMT
Update to Flexfind
Updated: Flexfind. Flexfind was updated to build 595 in which I fixed an issue when searching across multiple workbooks.
Mon, 1 Oct 2018 15:35:00 GMT