Welkom op de website van JKP Application Development Services

Wat ik doe

Diensten

Ik bied diensten aan met betrekking tot ieder aspect van Excel en VBA. De Diensten pagina bevat voorbeelden hiervan. U vindt er ook een lijst met recente projecten.

Producten

Ik ontwikkel maatwerkoplossingen in Excel voor klanten en ook Excel invoegtoepassingen voor algemeen gebruik zoals mijn spreadsheet audit tool RefTreeAnalyser. Bekijk hier producten die ik heb ontwikkeld.

Trainingen

Ga naar LinkedInLearning voor de enige Excel cursus die is gericht op ingenieurs: Excel for Engineering Professionals

Bekijk onze trainingen pagina, voor meer mogelijkheden.

Nieuwsbrief

Schrijf u in voor onze (Engelse) nieuwsbrief. Ik heb geen vaste frequentie maar de nieuwsbrief gaat hoe dan ook altijd over Excel.

Gratis Excel downloads

Ik ontwikkel maatwerk applicaties gebruik makend van Microsoft Office Excel® en VBA en Access en VBA. Bekijk de (gratis) downloads, waarvan enkele de facto standaard voor Excel ontwikkelaars zijn over de hele wereld.

Wie is Jan Karel?

Wilt u meer te weten komen over mij? Op deze pagina komt u iets meer te weten over mij en vind u een lijstje met enkele presentaties die ik de laatste jaren gegeven heb.

Prijzen

Nieuw op deze site

Engelse en/of Nederlandse artikelen

Office Script, more examples

I have added an example to my Office script examples page: how to filter a date column in a table for dates older than today.

Thu, 21 Mar 2024 10:50:00 GMT

Update: Name Manager

Name Manager has just been updated to build 706. Editing a name now also updates PowerQuery queries

Wed, 21 Feb 2024 15:30:00 GMT

Solving problems with VBA

I have just added a chapter to my article on solving startup problems in Excel, to solve an issue where Excel thinks it has lost the VBA code in a file

Wed, 14 Feb 2024 10:00:00 GMT

Updated: Flexfind

Flexfind was updated to add search and replace in Validation error message and input message text

Wed, 07 Feb 2024 15:00:00 GMT

Updated: Name Manager JavaScript edition

Today my Name Manager (JS edition) has been updated. Get your update by clicking in its task pane and pressing control+F5. Changes include: Bug fixes and slight Ux improvements

Tue, 06 Feb 2024 13:30:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has just been updated to version 3.1, build 206. New menu item: Select cells with hard-coded numbers

Tue, 30 Jan 2024 15:15:00 GMT

Updated: Name Manager JavaScript edition

Today my Name Manager (JS edition) has been updated. Get your update by clicking in its task pane and pressing control+F5. Changes include: Now you can delete multiple names in one go

Tue, 30 Jan 2024 14:30:00 GMT

Update: Name Manager

Name Manager has just been updated to build 705. Updated the Reset button code to solve an issue with the dialog screen not appearing

Tue, 16 Jan 2024 09:30:00 GMT

Updated: Flexfind

Flexfind was updated to fix a form resizing issue

Mon, 15 Jan 2024 13:55:00 GMT

Office Script, more examples

I have added an example to my Office script examples page: how to find the last used row in a range.

Tue, 09 Jan 2024 10:10:00 GMT

Updated: Name Manager JavaScript edition

Today my Name Manager (JS edition) has been updated. Get your update by clicking in its task pane and pressing control+F5

Mon, 08 Jan 2024 14:05:00 GMT

New: Name Manager JavaScript edition

Good news! Today my Name Manager (JS edition) has been officially accepted to the Microsoft store!

Tue, 02 Jan 2024 11:55:00 GMT

Update: Excel File Remediation Utility

The Excel File Remediation Utility has been updated to build 137. Fixed a couple of bugs and added exceptions to deleting names with external references.

Tue, 05 Dec 2023 09:55:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has just been updated to version 3.1, build 203. Added search in conditional formatting: databars, color scales and icon sets, Added Python support, Fixed bug in highlighting reference in formula, Fixed bug in Visualize, Fixed bug in insert link to ToC, Fixed bug in Formula report, now ignores text values starting with =

Thu, 09 Nov 2023 16:45:00 GMT

Updated: Table Tools

I have updated the TableTools add-in. Fixed a small bug in updating the queries

Tue, 24 Oct 2023 17:10:00 GMT

Updated: Flexfind JavaScript edition

Good news! Today I've updated my Flexfind (JS edition). To get the update, load the add-in in the usual way, click in it's pane and press control+F5

Mon, 16 Oct 2023 16:45:00 GMT

Updated: ExportVBAProject

I've fixed a small bug, if any of the VBA projects is protected the tool now gracefully exits. ExportVBAProject writes the components from a VBAProject to a single text file. Very useful if you need to compare the VBA code of two Excel files. Use a text compare tool like ExamDiff to compare differences in the exported files.

Thu, 28 Sep 2023 09:15:00 GMT

Update: Name Manager

Name Manager has just been updated to build 703. Removed 240 character limitation from the Edit RefersTo box

Thu, 31 Aug 2023 16:30:00 GMT

Updated: Flexfind

Flexfind was updated with an improved report (the List button)

Wed, 30 Aug 2023 13:55:00 GMT

Office Script, more examples

I have added an example to my Office script examples page: how to enter zeroes in all empty cells in a range.

Thu, 17 Aug 2023 11:10:00 GMT

Updated: Flexfind now searches all types of conditional formatting

Flexfind now also searches the formulas in conditional formatting rules such as data bars, color scales and icon sets

Tue, 20 Jun 2023 14:20:00 GMT

New tool: Cell Sizer add-in

This little add-in makes resizing rows and columns very simple.

Thu, 15 Jun 2023 16:30:00 GMT

New tool: Keeps the Queries and Connections task pane in check

This little add-in prevents an irritating habit of Excel: It reduces the width of the Queries and Connections pane very often.

Fri, 26 May 2023 12:35:00 GMT

I've added an international issues chapter to my article on Styles

If you use Styles in VBA, watch out for international issues!

Tue, 16 May 2023 16:55:00 GMT

Updated: Flexfind allows search and replace in VBA code

Good news: As of now, Flexfind allows you to Search and replace in VBA too!

Mon, 13 Mar 2023 10:55:00 GMT

New: Flexfind JavaScript edition

Good news! Today my brand new Flexfind (JS edition) has been approved for the Microsoft Office Add-ins store!

Thu, 19 Jan 2023 16:45:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has just been updated to version 3.1, build 190. Fixed a bug that caused run-time errors when using the Check Formulas option. Made the dialogs compatible with screen reader software for the visually impaired. First build that is Mac compatible!

Thu, 12 Jan 2023 15:55:00 GMT

Updated: An MSForms (all VBA) treeview.

Our All VBA treeview control has been updated to version 26.5. It has been improved for accessibility and is now compatible with the Windows Narrator screen reader (for the visually impaired).

Tue, 10 Jan 2023 15:45:00 GMT

Updated two tools: GithubVBAExporter and FollowCellPointer

I've Updated two tools today: GithubVBAExporter and FollowCellPointer. Find them on the download page.

Wed, 14 Dec 2022 14:30:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has just been updated to version 3.1, build 189. If your formula returns a range reference (like the XLOOKUP function does), RefTreeAnalyser will display to which cell(s) the formula points.

Wed, 02 Nov 2022 12:45:00 GMT

Video: Office Script And Power Automate Demo

I presented during the Excel Virtually Global conference October 17, 2022, Here's the recorded video: Office Script And Power Automate Demo

Mon, 17 Oct 2022 08:00:00 GMT

Excel Invoegtoepassingen werken niet

Een beveiliginsupdate heeft ervoor gezorgd dat Office bestanden met VBA code die je download (waaronder ook invoegtoepassingen) niet meer werken. Dit artikel laat zien hoe je dit probleem oplost.

Wed, 12 Oct 2022 09:25:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has just been updated to version 3.1, build 187. RefTreeAnalyser now also enables you to move your mouse over a sheet and see all cells with the same formula highlighted.

Thu, 22 Sep 2022 14:00:00 GMT

Update: Name Manager

Name Manager has just been updated to build 700. Fixed an issue pertaining to renaming and using the pickup function for users using an international keyboard

Thu, 22 Sep 2022 14:00:00 GMT

Update: Excel File Remediation Utility

The Excel File Remediation Utility has been updated to build 133. Fixed a bug in the logging routine which causes errors when Windows is using a period as the date separator. Please manually download the new version as it looks like the update process also causes errors.

Tue, 02 Aug 2022 10:55:00 GMT

Update: Name Manager

Name Manager has just been updated to build 696. Name Manager now works together with Charles Williams Lambda Explorer if you've got that installed

Tue, 26 Jul 2022 10:50:00 GMT

Update: Name Manager

Name Manager has just been updated to build 695. Fixed a bug regarding listing all names on a protected workbook

Mon, 18 Jul 2022 13:15:00 GMT

Updated : Flexfind

Flexfind has been updated: Added a textbox which displays the text in which your search string was found. Highlights the search string.

Wed, 13 Jul 2022 10:45:00 GMT

Update: Name Manager

Name Manager has just been updated to build 694. IT IS NOW FULLY COMPATIBLE WITH MAC EXCEL!

Wed, 13 Jul 2022 09:15:00 GMT

Updated : Table Tools

I have updated the TableTools add-in. I'm updating the add-in so it also works on Mac Excel

Mon, 06 Jun 2022 10:45:00 GMT

Updated: Excel tips & tricks

I've added three new Excel and VBA tips and tricks to the Tips and tricks page today.

Fri, 03 Jun 2022 12:00:00 GMT

Updated : Flexfind

Flexfind has been updated: Some improvements to the UI and to Mac compatibility

Fri, 27 May 2022 13:15:00 GMT

Updated : Flexfind

Flexfind has been updated: Now allows search in autoshapes. New: Mac compatible!

Wed, 25 May 2022 15:45:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has just been updated to version 3.0, build 177. RefTreeAnalyser now also enables you to add a table of external links to the Table Of Contents of your workbook.

Mon, 02 May 2022 10:15:00 GMT

Updated: Excel tips & tricks

I've added three new Excel and VBA tips and tricks to the Tips and tricks page today.

Wed, 20 Apr 2022 12:15:00 GMT

Updated: Enabling Drag and Drop between two Listboxes on a VBA Userform

I have updated the article about enabling drag and drop between two listboxes on an Excel userform with some improvements, like enabling multi-column listboxes. I've also fixed a couple of bugs.

Wed, 09 Mar 2022 13:20:00 GMT

New page: Excel tips & tricks

A new page featuring all sorts of Excel and VBA tips and tricks.

Fri, 25 Feb 2022 15:40:00 GMT

New article: Creating modern-looking userforms in VBA

The Microsoft VBA editor was designed somewhere around 1996. This means that the standard design of the userforms you create with that editor look really old-school if you don't do anything. Here I show how we might create a more modern-looking user-interface by changing some properties of the form and by using some tricks..

Wed, 16 Feb 2022 16:45:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has just been updated to version 3.0, build 175. The new feature to count all UDFs and LAMBDAs in your file has been vastly improved. And RTA now uses the top-left cell of a spill range to find formula precedents.

Mon, 14 Feb 2022 15:40:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has just been updated to build 174. Improved Select cells with dependents; Added counting UDF and LAMBDA functions.

Wed, 9 Feb 2022 15:45:00 GMT

Updated: Enabling Drag and Drop between two Listboxes on a VBA Userform

I have updated the article about enabling drag and drop between two listboxes on an Excel userform with some improvements, including making the target box scroll up or down when there are more items than fit in the height of the listbox.

Tue, 11 Jan 2022 10:30:00 GMT

Office Script, more examples

I have added an example to my Office script examples page. Office Script does not (yet) offer a way to prompt for input. I invented a work-around: Check for a presence of an input sheet. If not there, Insert it into the file and populate it with a prompt and labelled input cells. If it is already there, assume all inputs are ready and continue running the script and perform its actions.

Mon, 13 Dec 2021 16:45:00 GMT

Updated : Flexfind

Flexfind has been updated: Now allows search in threaded comments.

Mon, 06 Dec 2021 14:35:00 GMT

Office Script, The basics updated

I've updated this article with the new feature to start a script from a button on a sheet.

Tue, 30 Nov 2021 10:55:00 GMT

Office Script, De basis is bijgewerkt

Ik heb dit artikel bijgewerkt met een nieuwe optie om een script te starten middels een knop op het werkblad

Tue, 30 Nov 2021 10:55:00 GMT

Updated: Compare Two Tables

I've updated the tool with some UI improvements.

Mon, 15 Nov 2021 10:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated to build 170. Improved sorting of chart series nodes on Objects dialog and fixed truncation of some labels on dialogs.

Wed, 10 Nov 2021 10:45:00 GMT

A tombola, built in Excel

Excel is a very serious and powerful business application. That doesn't mean we can't have some fun with it. This file shows how to use circular references to have a tombola, no programming involved!

Fri, 29 Oct 2021 13:45:00 GMT

Updated: ExportVBAProject

I have updated this utility today. It now enables you to get a list of the properties of all userforms (including all their controls) appended at the end of the textfile. ExportVBAProject writes the components from a VBAProject to a single text file. Very useful if you need to compare the VBA code of two Excel files. Use a text compare tool like ExamDiff to compare differences in the exported files.

Thu, 28 Oct 2021 15:45:00 GMT

Updated: Compare Two Tables

I've updated the tool so it also works on files stored in Sharepoint or OneDrive.

Wed, 20 Oct 2021 09:45:00 GMT

Updated: Compare Two Tables

I've fixed a bug in the tool which caused the tool not to work with numeric indices.

Mon, 18 Oct 2021 16:30:00 GMT

Office Script, Called from Power automate

In this new article, I show you how to apply an Office Script to all Excel files in a OneDrive (for business) folder. The script adds a Table of Contents sheet (which neatly lists all worksheets and all charts) to each Excel file in the folder.

Fri, 08 Oct 2021 16:30:00 GMT

Office Script, enkele voorbeelden

Sinds Juli 2020 kunnen Microsoft 365 gebruikers hun acties in Excel laten opnemen als Office Script macro's. Eerder plaatste ik al een artikel dat laat zien hoe je hiermee start. Op deze pagina toon ik wat voorbeelden van Office scripts die je niet kunt opnemen met de Script recorder, maar die wel nuttig zijn.

Thu, 26 Aug 2021 13:05:00 GMT

Office Script, some examples

Since 2020, Microsoft 365 users can record their actions in Excel on-line into Office Script macros. This article shows example scripts which you cannot record but might come in handy.

Tue, 24 Aug 2021 15:45:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Fixed an issue with the links on each sheet back to the ToC.

Fri, 20 Aug 2021 13:30:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Added Tables to the table of content option.

Tue, 17 Aug 2021 17:20:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Added Form and ActiveX controls to the table of content option.

Fri, 13 Aug 2021 16:10:00 GMT

Importing Text Tiles In An Excel sheet

A long time ago I wrote an article about how to best import text files into Excel. I've updated the article today to include the PowerQuery steps.

Wed, 11 Aug 2021 15:00:00 GMT

Getting rid of the "cannot find your add-in" message

Many users struggle with getting rid of an Excel add-in. In this article I show how to fix the infamous "Sorry, we could not find..." error message.

Wed, 14 Jul 2021 14:45:00 GMT

A self-installing add-in

Many users struggle with getting an add-in installed. In this article I show some VBA code that will ease that process: As soon as the user opens the add-in and enables macros, the add-in offers to install itself.

Mon, 12 Jul 2021 13:40:00 GMT

Office Script, de basis

Sinds 2020 kunnen Microsoft 365 gebruikers hun acties in Excel online opnemen tot Office Script macro's. Dit artikel laat zien hoe je daarmee begint. Later zal ik nog wat voorbeeld scripts plaatsen die niet kunnen worden opgenomen, maar wel handig kunnen zijn.

Thu, 08 Jul 2021 13:45:00 GMT

Excel LAMBDA functie, de basis

Een artikel over de nieuwe Excel LAMBDA functie: hoe maak ik mijn eigen Excel functies.

Tue, 06 Jul 2021 12:40:00 GMT

Office Script, the basics

Since 2020, Microsoft 365 users can record their actions in Excel on-line into Office Script macros. This article shows you how to get started. Later on, I will list some example scripts which you cannot record but might come in handy.

Mon, 05 Jul 2021 16:00:00 GMT

Excel LAMBDA function, converting VBA UDFs to Lambda functions

The new Excel LAMBDA function: how to convert well-known VBA structures into combinations of Excel functions in a Lambda.

Tue, 08 Jun 2021 16:50:00 GMT

Excel LAMBDA function, the basics

An article about the new Excel LAMBDA function: how to create your own Excel functions.

Wed, 02 Jun 2021 14:15:00 GMT

Updated various tools

I have updated GitHubVBAExporter, the form is now sizable.

Wed, 28 Apr 2021 11:00:00 GMT

Update: Name Manager

Name Manager has just been updated to build 681 with some bugfixes

Thu, 15 Apr 2021 13:10:00 GMT

Updated various tools

I have updated a number of tools to cater for some 64 bit issues and other things. These include files such as Name Manager, FlexFind, GitHubVBAExporter, Autosafe.

Mon, 22 Mar 2021 12:30:00 GMT

Updated: Github VBA exporter

I've updated Github VBA Exporter. It now allows you to also export add-ins. This utility enables you to export all components from a VBAProject to a user-selectable set of folders. Very useful if you need to upload the contents of a VBA project into Github. The tool generates a textfile which contains all properties of all userforms and their controls, and the ribbonX is exported too, which enables you to do diff's on your user interface.

Thu, 18 Mar 2021 11:50:00 GMT

A new tool: Github VBA exporter

I've added a tool (in beta!!) to my download section called Github VBA Exporter. This utility enables you to export all components from a VBAProject to a user-selectable set of folders. Very useful if you need to upload the contents of a VBA project into Github. The tool generates a textfile which contains all properties of all userforms and their controls, and the ribbonX is exported too, which enables you to do diff's on your user interface.

Wed, 13 Jan 2021 10:30:00 GMT

Update: Name Manager

Name Manager has just been updated to build 675. You can now filter for Lambda names and you can edit name comments

Mon, 14 Dec 2020 13:55:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Added two new options: 1. Generate a Table of Contents and 2. Added a feedback button which takes you to a small survey so you can tell me what you like and what you do not like.

Fri, 04 Dec 2020 11:00:00 GMT

Video: Smart Macro Recording

I presented during the Excel Virtually Global conference in July 2020, Here's the recorded video: Smart VBA Macro Recording

Mon, 24 Aug 2020 16:15:00 GMT

Updated article: Prevent Open Event

I have updated my existing article on how to prevent Open events from running as Microsoft has changed the way Excel responds to the Shift key being held down (it now ignores it).

Thu, 13 Aug 2020 16:15:00 GMT

Enabling Drag and Drop between two Listboxes on a VBA Userform

I have added an article today which shows how to enable drag and drop between two listboxes on an Excel userform

Wed, 10 Jun 2020 10:30:00 GMT

Gegevenstypen gebruiken in Excel

Ik heb een artikel toegevoegd over het gebruik van Gegevenstypen in Excel.

Thu, 21 May 2020 16:00:00 GMT

Using Data Types in Excel

I have added an article today about data types in Excel.

Fri, 08 May 2020 15:20:00 GMT

A Generic Spreadsheet Template

I have added an article today about what every spreadsheet models should contain. With a free download too!

Fri, 01 May 2020 17:40:00 GMT

Een Generiek Spreadsheet Sjabloon

Ik heb een artikel toegevoegd vandaag over wat er in ieder goed Excel bestand zou moeten zitten. Met gratis download.

Fri, 01 May 2020 17:40:00 GMT

The Excel VBA Masterclass

I have scheduled a new run of my Excel VBA Masterclass for these dates: May 18, 20, 26 and 28, 2020 June 2 and 4, 2020. The masterclass will be completely on-line, using Microsoft Teams. Make sure you register now

Thu, 23 Apr 2020 09:25:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Added PowerQuery M code to Object search. Fixed a bug regarding finding cell references in Objects

Wed, 15 Apr 2020 10:55:00 GMT

Updated: Compare Two Tables

I've fixed two bugs in the tool.

Fri, 10 Apr 2020 15:00:00 GMT

Update: Name Manager

Name Manager has just been updated to build 672. Range names generated by the new LET function are now correctly identified as system names

Wed, 1 Apr 2020 10:40:00 GMT

Update: Name Manager

Name Manager has just been updated to build 671. When a name is renamed, PowerQuery M code will be checked for existence of the name and updated accordingly

Fri, 21 Feb 2020 13:40:00 GMT

Webinar recording: Working with tables in Microsoft Excel

Ever used Format as Table in Microsoft Excel? Did you know Format as Table can be a whole lot more than just fancy formating? Join Jan Karel Pieterse as he discusses working with tables and how they can help you in your everyday work with Excel.

Fri, 31 Jan 2020 10:50:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. You can now choose whether or not to display references in your formula more than once

Wed, 15 Jan 2020 09:20:00 GMT

Updated : Table Tools

I have updated the TableTools add-in, with a couple of bug fixes.

Mon, 13 Jan 2020 13:30:00 GMT

The Excel VBA Masterclass

I have scheduled a new run of my Excel VBA Masterclass. Make sure you register now

Tue, 26 Nov 2019 12:45:00 GMT

New download: Excel Spreadsheet Model Template

To help in the battle towards better spreadsheets I have uploaded an Excel Spreadsheet Model Template.

Wed, 20 Nov 2019 09:05:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Fixed the wrong calculation setting (use 1 core only) of the add-in

Tue, 12 Nov 2019 09:45:00 GMT

Update: Excel File Remediation Utility

The Excel File Remediation Utility has been updated to build 128. Added "Copy sheet special" item to right-click menu of worksheet tabs.

Thu, 31 Oct 2019 09:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved the layout of the Object references dialog

Wed, 30 Oct 2019 16:15:00 GMT

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 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 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.

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

Update: Name Manager

Name Manager has just been updated to build 664. Name Manager will no longer mark names using the new Dynamic Array references as names with errors.

Wed, 26 Sep 2018 15:45:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. It now works with the new Excel Data Types (Geography and Stock) and with the new Dynamic Array references.

Wed, 26 Sep 2018 15:15:00 GMT

Update: Name Manager

Name Manager has just been updated to build 660. In case of a compile error, Name Manager will automatically turn off its feature to display a toolbar in the VBA editor.

Tue, 04 Sep 2018 16:00:00 GMT

Update: Name Manager

Name Manager has just been updated to build 659. Fixed a problem 64 bit Excel users might experience.

Mon, 03 Sep 2018 16:35:00 GMT

Update: HeaderFooter

My HeaderFooter tool has been made 64 bit compliant.

Fri, 24 Aug 2018 14:05:00 GMT

Update: Name Manager

Name Manager has just been updated to build 958. Fixed a problem caused by a Windows 10 bug.

Fri, 06 Jul 2018 14:05:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved performance of formula checking and reporting significantly.

Thu, 14 Jun 2018 19:05:00 GMT

Update: Privacy Beleid JKP-ADS

Ik weet het, saaaaai. Maar het moest er van komen ivm de AVG. Ons Privacy Beleid is aan onze site toegevoegd.

Mon, 28 May 2018 10:25:00 GMT

Update: Company Privacy Policy

I know, boring, but it had to be done thanks to the GDPR. Our Company Privacy Policy has been added to our website.

Mon, 28 May 2018 10:25:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Adapted site addresses to use https.

Thu, 24 May 2018 16:15:00 GMT

Update: Excel File Remediation Utility

The Excel File Remediation Utility has been updated to build 123. Adapted site addresses to use https.

Thu, 24 May 2018 16:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Fixed runtime error due to third-party add-ins when checking if tool is installed.

Wed, 02 May 2018 16:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Included Array formulas in circular reference checks.

Mon, 09 Apr 2018 17:00:00 GMT

Gebruikers-vriendelijke gegevensvalidatie met weergave van hulp die niet in de weg staat

Ik heb een artikel toegevoegd vandaag over hoe je Gebruikers-vriendelijke gegevensvalidatie met weergave van hulp die niet in de weg staat maakt in Excel.

Sat, 17 Mar 2018 16:00:00 GMT

Creating a user-friendly Data Validation in Excel Displaying help out of the way

I have added an article today about Creating a user-friendly Data Validation in Excel Displaying help out of the way, not on top of your cells in your form.

Thu, 01 Mar 2018 16:00:00 GMT

The Amsterdam Excel Summit 2018: Dates are set!

Come and join us in Amsterdam on June 7 and 8, 2018 for our fifth famous Amsterdam Excel Summit. We have just fixed the dates so make sure you Visit the Amsterdam Excel Summit Website

Tue, 20 Feb 2018 16:40:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved performance of looking for dependents.

Wed, 15 Nov 2017 17:30:00 GMT

Name manager updated

Name Manager for Excel has been updated. Fixed an issue caused by a Windows 10 bug. Renaming a name now also fixes hyperlinks using that name

Tue, 31 Oct 2017 10:50:00 GMT

Update: Excel File Remediation Utility

The Excel File Remediation Utility has been updated to build 121. We have improved performance on a number of areas and added a way to report detailed statistics of multiple files.

Mon, 02 Oct 2017 17:05:00 GMT

New tool: Table Tools

I have added an add-in to my site called Table Tools. This add-in makes your daily life with Excel tables a little simpler!

Wed, 20 Sep 2017 08:30:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved the formula report

Mon, 18 Sep 2017 15:30:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved performance on analysing conditional formatting formulas

Tue, 15 Aug 2017 13:20:00 GMT

Cocreatie in Office 365

Ik heb vandaag een artikel toegevoegd over Cocreatie in Excel 2016

Thu, 29 Jun 2017 07:00:00 GMT

Co-authoring in Office 365

I have added an article today about co-authoring in Excel 2016

Fri, 23 Jun 2017 16:00:00 GMT

Updated article: Declaring API functions in 64 bit Office

I have added a Windows API function declaration for Office 64 bit to the list: URLDownloadToFile

Thu, 08 Jun 2017 17:15:00 GMT

Update to Flexfind

Updated: Flexfind. Flexfind was updated to build 592 in which I changed the default search scope to just the active workbook.

Wed, 7 Jun 2017 07:05:00 GMT

Access backup tool updated

I have updated my Access Backup utility so it now also orks on 64 bit Access.

Wed, 10 May 2017 08:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Finally fixed an intermittent issue with the Visualize functionality on Excel 2016

Mon, 08 May 2017 16:20:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved performance for Excel 2013 and 2016

Wed, 26 Apr 2017 14:20:00 GMT

Our Amsterdam Excel Summit was great

Our Amsterdam Excel Summit has been a great success. We had two very well received days full of Excel and Power BI sessions. Find links to photo impressions on my events page.

Tue, 25 Apr 2017 10:40:00 GMT

Update: Excel File Remediation Utility

Our Excel File Remediation Utility has just been updated. I have added an option to remove all styles from the workbooks. This is very useful if you have Excel files with corrupt styles.

Thu, 23 Mar 2017 15:40:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Added jump to pivotsource when you trace precedents when in a pivottable.

Fri, 03 Mar 2017 13:00:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Fixed issue regarding range names in formulas.

Sun, 19 Feb 2017 13:20:00 GMT

Update to Flexfind

Updated: Flexfind. Added support for replacing in Powerquery M code (Excel 2016).

Sat, 18 Feb 2017 19:10:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Fixed issue with short-cut keys not responding immediately after openening Excel.

Wed, 15 Feb 2017 07:50:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. I have fixed a bug, Pivottables were not listed when pointing to a table name.

Thu, 9 Feb 2017 09:45:00 GMT

The Amsterdam Excel Summit 2017: Registration is open

Come and join us in Amsterdam on April 18 and 19 2017 for our famous Amsterdam Excel Summit. We have just opened registration so make sure you book your seats before Feb 20 and receive a nice early-bird discount! Visit the Amsterdam Excel Summit Website

Mon, 16 Jan 2017 16:20:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. I have improved scrolling the selected cells into the viewable area of the screen

Thu, 5 Jan 2017 06:25:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Fixed three bugs.

Wed, 14 Dec 2016 20:55:00 GMT

Name manager updated

Name Manager for Excel has been updated. Fix for finding dynamic range names when using the Formulas or 2D areas filter.

Tue, 13 Dec 2016 15:20:00 GMT

a Simple Inventory System, built in Excel

Answering questions on forums can be very rewarding. This post is the result of a forum question. The forum member needed a simple system to manage his shop inventory. He wanted to be able to log Purchases, Reservations and Sold items and immediately be kept informed when items are (almost) out of stock..

Tue, 11 Oct 2016 13:15:00 GMT

A wheel of Fortune, built in Excel

Excel is a very serious and powerful business application. That doesn't mean we can't have some fun with it. In this article I'll explain how I've built an Excel file which enables you to play with a wheel of fortune. With sound and all!.

Thu, 29 Sep 2016 17:45:00 GMT

Excel add-ins fail to load

A recent Office update may cause your add-ins to be ignored by Excel. This article shows you how to fix that.

Wed, 17 Aug 2016 15:45:00 GMT

Updated: FollowCellPointer

I have just updated the small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Fix: enabled for 64 bit Excel.

Mon, 15 Aug 2016 09:00:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. I have added an option to display your formula as a mathematical equation.

Tue, 21 Jun 2016 14:55:00 GMT

Updated: An MSForms (all VBA) treeview.

Our All VBA treeview control now has a professional version which is ready for beta testing.

Thu, 16 Jun 2016 15:50:00 GMT

An MSForms (all VBA) listgrid.

Our All VBA treeview control now has a sister control: the ListGrid. This brand new control is ready for beta testing.

Thu, 16 Jun 2016 15:50:00 GMT

Register now: The Excel VBA Masterclass

We have just opened registration for The Excel VBA Masterclass. Course dates October 26 and 27, 2016.

Tue, 14 Jun 2016 14:10:00 GMT

curves fitten met de kleinste kwadraten methode

Als je (net als ik, voordat ik Excel specialist werd) ingenieur bent, dan heb je waarschijnlijk het nodige aan experimeteerwerk gedaan. Vaak heb je dan een methode nodig om je meetresultaten te fitten met een kromme. En als je een echte ingenieur bent, dan heb je ook al een goed idee wat de soort vergelijking is de theoretisch bij je metingen zou moeten passen.

Tue, 12 Apr 2016 07:50:00 GMT

Een klasse om VBA performance te meten

Ik ben er eindelijk aan toe gekomen een artikel te vertalen. Dit artikel beschrijft een methode om eenvoudig de performance van je VBA routines te meten.

Tue, 17 May 2016 07:50:00 GMT

Update to Flexfind

Updated: Flexfind. Improved selecting objects.

Thu, 21 Apr 2016 08:50:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. I have improved the off-sheet references report to include tables and range names.

Fri, 8 Apr 2016 15:50:00 GMT

New training: Excel VBA Mafsterclass

We have just published the course outline of our new training: Excel VBA Masterclass.

Mon, 29 Feb 2016 07:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Added an off-sheet references report which visualises the inter-sheet formula links of your workbook.

Sat, 27 Feb 2016 15:35:00 GMT

Update to Flexfind

Updated: Flexfind. I have added support for searching and replacing in the first page headers and footers.

Thu, 04 Feb 2016 09:50:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. I have added an auto-update option.

Tue, 19 Jan 2016 08:25:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. I fixed a small bug in getting values from entire columns. This is the last update for the Excel 2003 version of the add-in.

Tue, 15 Dec 2015 12:45:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. I Improved the performance of finding dependents and improved how Objects are listed.

Wed, 25 Nov 2015 11:35:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. I fixed a small bug causing a runtime error when you close Excel.

Wed, 07 Oct 2015 20:30:00 GMT

Tool to help close all Excel windows

With the new MDI interface introduced with Excel 2013, closing all workbooks has become unnecessary difficult. This little addin adds a 'Quit Excel' button to your File menu that will close all open workbooks and quit Excel. It also features a Short-cut key: control+q

Thu, 01 Oct 2015 09:30:00 GMT

Celebrating 30 years of Excel with 30 days 30% discount!

To celebrate the fact that Excel was launched 30 years ago (September 30, 1985) we're having an anniversary sale at jkp-ads.com. From September 30 to October 30, 2015 we offer a 30 % discount on both our products: RefTreeAnalyser and The Excel File Remediation Utility

Thu, 01 Oct 2015 08:50:00 GMT

Solving problems with Office caused by Windows 10

I have just added a chapter to my article on solving startup problems in Excel, especially for the people who are experiencing issues after upgrading their computer to Windows 10

Wed, 16 Sep 2015 13:35:00 GMT

Update to Flexfind

Updated: Flexfind. I have recently fixed a bug in Flexfind where the tool appears to make Excel 2013 unresponsive. The root cause of the problem was the new MDI interface of Excel which forced us to make the Flexfind window the topmost window, thus causing message boxes to appear behind the window in some situations.

Mon, 14 Sep 2015 10:05:00 GMT

Summer sale at jkp-ads.com

Yes we're having a summer sale at jkp-ads.com. From July 1 to July 10 we offer a 25 % discount on both our products: RefTreeAnalyser and The Excel File Remediation Utility

Thu, 25 Jun 2015 06:15:00 GMT

New product: The Excel File Remediation Utility

I have launched a product you can try and buy directly from my site: The Excel File Remediation Utility. This tool helps you to try and salvage Excel models with problematic content accumulated during a long editing history.

Thu, 25 Jun 2015 06:15:00 GMT

Registratie geopend: Excel VBA voor Financials V5

Excel VBA voor Financials versie 5; Een twee-daagse Excel VBA cursus (6, 14 en 21 oktober 2015). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte!

Mon, 22 Jun 2015 15:45:00 GMT

Een Excel artikel: Bouwen van een invoegtoepassing voor Excel

Vandaag een artikel geplaatst over het maken van een invoegtoepassing in Excel. Alle stappen die je nodig hebt om een eenvoudige invoegtoepassing te maken worden erin beschreven.

Mon, 08 Jun 2015 15:40:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. I have added support for hotkeys using the Alt key.

Wed, 06 May 2015 17:30:00 GMT

New Excel article: Building an Add-in for Excel

Today I posted an entirely new article. It describes all the steps needed to create a basic Excel add-in.

Mon, 04 May 2015 14:10:00 GMT

Link posted to Andrew's Excel Utilities

Today I posted a link to one of the most comprehensive sets of Excel productivity tools I have ever seen: Andrew's Excel Utilities

Tue, 07 Apr 2015 08:30:00 GMT

The Amsterdam Excel Summit 2015: Last minute discount

Our event is coming real soon now and we're very much looking forward to it. We have outstanding speakers and excellent content, so everything is lined up to make this a superb Excel event. To entice the undecisive Excel lovers to make up their minds and subscribe after all, we decided to make it even more attractive to attend. As of March 27st, 2015 we offer a € 200 last-minute discount per attendee for both days and € 100 for one day! Register now at http://topexcelclass.com/index.php/amsterdam-excel-summit/registration/ and meet us on April 13th and 14th in Amsterdam.

Fri, 27 Mar 2015 08:20:00 GMT

The Amsterdam Excel Summit 2015: Great content!

Extended early bird discount on our Amsterdam Excel Summit! Last week our mail server experienced some problems, which meant that the registration form did not work. To compensate for anny inconvenience caused by this problem we have decided to extend the early bird discount period with an additional week. So register before March 1st 2015 and receive the 50 Euro discount!

Mon, 23 Feb 2015 14:40:00 GMT

Updated article: Working with Circular references in Excel

In my Circular Reference article I promised to include an example of a VBA driven circular reference calculation. I have done that today so head over to my site to check it out!

Wed, 11 Feb 2015 09:30:00 GMT

The Amsterdam Excel Summit 2015: Great content!

Join us in Amsterdam on April 13th and 14th 2015, for the second Amsterdam Excel Summit! We have a lot of interesting subjects, including: Business Intelligence in Excel vNext, An introduction to Power Query, working with Excel charts less painful, Professionalising your Power Pivot Model, More efficient VBA UDFs, ...

Tue, 10 Feb 2015 17:20:00 GMT

Name manager updated

Name Manager for Excel has been updated. Improved renaming rangenames in VBA code.

Tue, 10 Feb 2015 17:20:00 GMT

The Amsterdam Excel Summit 2015: Registration is now open!

Join us in Amsterdam on April 13th and 14th 2015, for the second Amsterdam Excel Summit! An absolute unique group of Excel MVPs will gather in Amsterdam to share their expert knowledge with you. The Excel MVPs happen to be in Amsterdam for a meeting and we've succeeded in getting some of them to present at our event. Make sure you register!

Thu, 22 Jan 2015 10:15:00 GMT

Registratie geopend: Excel VBA voor Financials V2

Excel VBA voor Financials versie 2; Een twee-daagse Excel VBA cursus (20 en 26 mei 2015). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !

Tue, 30 Dec 2014 13:05:00 GMT

Update: GoBack.

Finally got some time to include an Excel 2007-2013 version of this little tool that traces where you went in your Excel files and gets you back easily!

Wed, 19 Nov 2014 06:45:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. I have added an option to report all unique formulas in your workbook. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Thu, 23 Oct 2014 16:45:00 GMT

Celebrating my MVP award: Discount offer

Every quarter Microsoft announces who are the lucky ones to receive their Most Valuable Professional Award. I got re-awarded! To celebrate that I am offering a 3 day 50 percent discount on RefTreeAnalyser. From October 8, 2014 to October 10, 2104 you receive 50 % off of the list price when you enter this coupon code: MVP2014 Head over to my website now and download the tool, you can try it for free!

Tue, 07 Oct 2014 09:30:00 GMT

Registratie loopt erg goed: Excel VBA voor Financials

Onze cursus Excel VBA voor Financials blijkt populari. Haast u als u mee wilt doen! Een twee-daagse Excel VBA cursus (19 november en 3 december 2014). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !

Thu, 02 Oct 2014 16:00:00 GMT

Registratie geopend: Excel VBA voor Financials

Excel VBA voor Financials; Een twee-daagse Excel VBA cursus (19 november en 3 december 2014). Bespaar tijd door het automatiseren van uw rapportages! Ontsluier de geheimen van VBA en breng uw Excel kennis en vaardigheden op ongekende hoogte !

Mon, 08 Sep 2014 15:35:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved performance of formula checking and added formula block highlighting. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Fri, 20 Jun 2014 15:50:00 GMT

Commenting has been fixed

I somehow managed to break the commenting function of my site. Today I fixed it again and you can go ahead and ask your questions or add your comments once more.

Mon, 02 Jun 2014 06:30:00 GMT

Update to Flexfind: Bugfix regarding replacing in cells with Values

My free Flexfind tool for Excel has been updated to build 584. Fixed a bug regarding replacing when search was done in Values.

Thu, 08 May 2014 09:35:00 GMT

Registratie sluit binnenkort! The Amsterdam Excel Summit 2014

Wees er nu echt snel bij, want de registratie sluit al op 7 mei! Op 14 mei 2014 organiseren wij in Amsterdam de eerste "Amsterdam Excel Summit". Een absoluut unieke groep Excel MVPs zal in mei 2014 in Amsterdam zijn om hun geweldige Excel kennis met u te delen. Deze MVPs zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd om deze mensen voor ons evenement te boeken. Er is slechts weinig kans dat een dergelijke mogelijkheid zich nogmaals zal voordoen, dus wees er snel bij als u dit niet wilt missen!

Mon, 28 Apr 2014 10:15:00 GMT

Registration closes soon! The Amsterdam Excel Summit 2014

Be quick to join us in Amsterdam on May 14 2014, for the registration on the first Amsterdam Excel Summit closes on May7th! An absolute unique group of Excel MVPs will gather in Amsterdam to share their expert knowledge with you. The Excel MVPs happen to be in Amsterdam for a meeting and we've succeeded in getting some of them to present at our event. There is not much chance on this happening again anytime soon, so make sure you register!

Mon, 28 Apr 2014 10:15:00 GMT

New page: A VBA performance class

I have added an article to my site, describing a class module to help measuring your VBA performance.

Tue, 15 Apr 2014 17:15:00 GMT

Een Kringverwijzingen in Excel

Als je wel eens die vervelende melding hebt gehad over kringverwijzingen toen je een formule maakte of toen je een Excel bestand opende, lees dan dit nieuwe artikel. Excel detecteert een kringverwijzing zodra een reeks formules ertoe leidt dat dezelfde cel meer dan eens in serie berekeningen wordt aangedaan. Veel gebruikers vinden de kringverwijzingen melding uiterst verwarrend en hebben geen idee waardoor die verschijnt. In dit artikel tracht ik het mysterie omtrent deze situatie weg te nemen.

Mon, 14 Apr 2014 11:00:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Added hotkeys for Check Formulas and for Objects. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Thu, 03 Apr 2014 16:00:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved reporting and fixed a bug or two. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Mon, 31 Mar 2014 17:30:00 GMT

New page: Pivottable Slicers, Showing selected Slicer items on a worksheet

I have added a page to my article on Slicers, which shows you how to get the selected items of a slicer into a worksheet cell.

Fri, 21 Mar 2014 15:45:00 GMT

Update: Startup Problems

I have updated the page on Excel startup problems today with information about a newly discovered tool, the Office Configuration Analyzer Tool (OffCAT).

Thu, 20 Mar 2014 16:15:00 GMT

New page: Pivottable Slicers, Synchronising slicers

I have added a page to my article on Slicers, which shows you how to synchronise slicers which drive different PivotCaches.

Thu, 13 Mar 2014 17:15:00 GMT

Aankondiging: The Amsterdam Excel Summit 2014

Op 14 mei 2014 organiseren wij in Amsterdam de eerste "Amsterdam Excel Summit". Een absoluut unieke groep Excel MVPs zal in mei 2014 in Amsterdam zijn om hun geweldige Excel kennis met u te delen. Deze MVPs zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd om deze mensen voor ons evenement te boeken. Er is slechts weinig kans dat een dergelijke mogelijkheid zich nogmaals zal voordoen, dus wees er snel bij als u dit niet wilt missen!

Thu, 13 Feb 2014 15:40:00 GMT

Anouncing: The Amsterdam Excel Summit 2014

Join us in Amsterdam on May 14 2014, for the first Amsterdam Excel Summit. An absolute unique group of Excel MVPs will gather in Amsterdam to share their expert knowledge with you. The Excel MVPs happen to be in Amsterdam for a meeting and we've succeeded in getting some of them to present at our event. There is not much chance on this happening again anytime soon, so make sure you register!

Thu, 13 Feb 2014 15:40:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Prevented opening of unneeded blank workbook. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Fri, 24 Jan 2014 13:40:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Made searching in Objects optional for searching precedents and dependents to improve performance. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Fri, 24 Jan 2014 13:40:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Fixed a small bug introduced with searching in Objects. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Wed, 22 Jan 2014 14:10:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Now if you're tracing precedents or dependents objects (such as pivot tables, charts, data validation, Conditional formatting, ...) are also traced for cell dependencies. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Tue, 14 Jan 2014 08:20:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Now you can analyse all your Excel objects (such as pivot tables, charts, data validation, Conditional formatting, ...) for cell dependencies. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Tue, 07 Jan 2014 17:00:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved placement of pictures of far-away cells. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Wed, 06 Nov 2013 12:30:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Visualisation colors can now be changed. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Fri, 01 Nov 2013 16:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Visualize precedents has been made available for Excel 2003 too. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Wed, 30 Oct 2013 12:35:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Added a new option to the tool: Visualize precedents. The precedents of a cell are visualised directly on the worksheet, a vast improvement on the built-in show precedents option. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Wed, 23 Oct 2013 16:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved the reporting function. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Thu, 17 Oct 2013 16:10:00 GMT

Update to Flexfind: Bugfix regarding replacing dates

My free Flexfind tool for Excel has been updated to build 581. It now handles replacement of dates better.

Tue, 15 Oct 2013 15:25:00 GMT

A new tool: Trusted Documents Manager

I have just published a tool today, Trusted Documents Manager. This little tool enables you to manage your list of trusted documents. Currently, Excel only allows you to either leave the list intact, or delete the entire list. This means all of your currently trusted documents become untrusted again so you have to enable macro's on all of them once again. The tool allows you to remove just one file, remove an entire folder or even an entire drive. Also it offers to possibility to remove files which no longer exist from the list.

Thu, 10 Oct 2013 13:30:00 GMT

Updated: An MSForms (all VBA) treeview.

Our All VBA treeview control for Office has been updated to build 025. We've added a ControlTipText property and fixed a small bug regarding scrolling horizontally when checking a node.

Wed, 02 Oct 2013 12:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved tracing errors function. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Wed, 02 Oct 2013 09:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Small bugfix regarding handling of windows in Excel 2013. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Mon, 30 Sep 2013 10:30:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Important update: fixed some bugs in the multi-level precedents searching. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Wed, 25 Sep 2013 10:45:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved the error tracing and fixed a problem with the Stop button. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Mon, 23 Sep 2013 09:05:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Fixed a bug for Excel 2013 (another messagebox was hidden from view by the appl. interface). Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Fri, 20 Sep 2013 13:30:00 GMT

Updated article: Keeping Userforms on top of SDI windows in Excel 2013 and up

The previous solution I developed for this problem had a serious drawback: messageboxes would show behind the userform. This new solution is simpler and does not have that problem.

Fri, 20 Sep 2013 13:30:00 GMT

Name manager updated

Name Manager for Excel has been updated. Improved window handling for Excel 2013.

Mon, 09 Sep 2013 17:30:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Fixed a bug for Excel 2013 (messageboxes are hidden from view by the appl. interface). Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Wed, 28 Aug 2013 11:30:00 GMT

Name manager updated

Name Manager for Excel has been updated. Added Italian user interface language.

Wed, 21 Aug 2013 16:10:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Improved returning to the original selection after closing the tool. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Fri, 07 Jun 2013 13:00:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Fixed some minor issues regarding use in Excel 2003. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Sun, 26 May 2013 10:20:00 GMT

Updated: An MSForms (all VBA) treeview.

Our All VBA treeview control for Office has been updated to build 024. We have now included properly working examples for Word and Access!

Mon, 20 May 2013 14:10:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser 2.0 has just been updated. Now you can change the hotkeys. People who are using version 2 will be automatically prompted for this update. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Fri, 03 May 2013 14:00:00 GMT

Queen's day sale: RefTreeAnalyser (version 2!) 50 percent rebate

Anyone who places an order between April 30, 2013, 8:00 AM GMT and May 1st, 2013 8:00 AM GMT will receive a 50 % rebate on the list price. I'm also going to give away some of the licenses: I'll randomly select 1 out of every 10 orders placed in that period of time These people will receive a complimentary license.

Mon, 29 Apr 2013 19:40:00 GMT

Koninginnedag uitverkoop: RefTreeAnalyser (version 2!) 50 procent korting

Koninginnedag uitverkoop! Alle bestellingen geplaatst tussen 30 april 10:00 's morgens en 1 mei 10:00 uur 's morgens (Nederlandse zomertijd) krijgen 50 procent korting. Bovendien verloot ik een gratis licentie per 10 geplaatste bestellingen.

Mon, 29 Apr 2013 19:40:00 GMT

Major Update: RefTreeAnalyser (version 2!)

RefTreeAnalyser has been completely updated to version 2.0. This new version also works on the 64 bit versions of Office. Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Wed, 24 Apr 2013 16:25:00 GMT

Updated: An MSForms (all VBA) treeview.

Our All VBA treeview control for Office has been updated to build 021.

Thu, 14 Mar 2013 13:10:00 GMT

New article and download: An MSForms (all VBA) treeview.

We have created a treeview for Office VBA that will work on any version of Office as of Office 2000, including 64 bits and MAC Office! If you have ever used the Treeview control from the "Additional controls" section, then you know what a versatile control this is to show hierarchically organized data. There are a couple of problems with this Treeview control: You risk compile errors and -worse- it will not work on 64 bit Office..

Thu, 21 Feb 2013 14:30:00 GMT

Update to Autosafe

I've updated Autosafe with new translations for German.

Tue, 29 Jan 2013 15:30:00 GMT

Update: RefTreeAnalyser (build 1.0.31)

RefTreeAnalyser has been updated. I have changed how hidden sheets are handled (no more messageboxes). Do you have a license? Then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Wed, 02 Jan 2013 14:05:00 GMT

Keeping Userforms on top of SDI windows in Excel 2013 and up

With the introduction of Excel 2013, Microsoft changed the windowing of Excel. On all previous versions, Excel had a so-called Multiple Document Interface (MDI), which means all open Excel files are hosted by one Excel application window. Excel 2013 introduced a Single Document Interface, meaning each workbook appears in its own Excel window. This new feature of Excel causes some trouble with modeless userforms. This article shows you how to resolve the issues involved.

Mon, 26 Nov 2012 14:45:00 GMT

Update to Flexfind: Flexfind now handles Excel 2013 new SDI interface

My free Flexfind tool for Excel has been updated to build 577. It now properly keeps its dialog on top of all Excel 2013 windows.

Wed, 21 Nov 2012 14:55:00 GMT

Update to Flexfind: Bugfix regarding non-English formulas

My free Flexfind tool for Excel has been updated to build 575. Fixed a problem with searching in Forumlas in non-English versions of Excxel.

Tue, 13 Nov 2012 16:35:00 GMT

Name manager updated

Name Manager for Excel has been updated. Fixed a small issue with regards to updating the LinkedCell property when renaming.

Thu, 21 Jun 2012 06:20:00 GMT

New tool: ControlLister.

I have added my control lister to my download page today, this tool lists all controls on your userforms on a worksheet. Includes code to rebuild the userforms from the table.

Thu, 14 Jun 2012 16:30:00 GMT

Updated article: Declaring API functions in 64 bit Office

I have added a couple of new Windows API function declarations for Office 64 bit to the list.

Wed, 06 Jun 2012 18:45:00 GMT

Name manager updated

Name Manager for Excel has been updated. Fixed a small issue with regards to replacing rangenames in VBA code. Now it also handles range names in square brackets such as [TheName].

Mon, 4 Jun 2012 08:20:00 GMT

Working with Circular references in Excel

If you've ever experienced the "Circular reference warning" popping up when you opened an Excel file read this new article. Excel detects a circular reference when a chain of calculations visits the same cell more than once. Many users get (very) confused by this message and have no idea what it is about. I'll try to demystify that message here!

Wed, 02 May 2012 15:30:00 GMT

Fitting curves to your data using least squares

If you're an engineer (like I used to be in a previous life), you have probably done your bit of experimenting. Usually, you then need a way to fit your measurement results with a curve. If you're a proper engineer, you also have some idea what type of equation should theoretically fit your data. Excel provides us with a couple of tools to perform Least Squares calculations, but they are all centered around the simpler functions: simple Linear functions of the shape y=a.x+b, y-a.exp(b.x), y=a.x^b and etcetera. What if you want to fit a more complex function, like y=exp(a.x).sin(x) + b ? How can that be done using Excel? This article shows a way to do this.

Thu, 12 Apr 2012 15:25:00 GMT

Update: RefTreeAnalyser (build 1.0.30)

RefTreeAnalyser has been updated. I have fixed a bug in the reporting option of the tool. Do you have a license? Then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Thu, 29 Mar 2012 13:05:00 GMT

Update: RefTreeAnalyser (build 1.0.29)

RefTreeAnalyser has been updated. I have fixed a tiny bug which caused the tool to generate a runtime error when you close Excel without any open workbooks. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Tue, 14 Feb 2012 15:25:00 GMT

Update to Flexfind: Bugfix for Excel 2010

My free Flexfind tool for Excel has been updated to build 574. Excel 2010 caused problems with searching for the category Axis title.

Fri, 10 Feb 2012 08:35:00 GMT

Update: RefTreeAnalyser (build 1.0.28)

RefTreeAnalyser has been updated. I have fixed a bug regarding hidden worksheets, which could cause the tool to generate runtime errors. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Thu, 26 Jan 2012 06:55:00 GMT

Web paginas maken met Excel Web App mashups

Met het op de markt komen van Excel 2010, heeft Microsoft ook de mogelijkheid geintroduceerd om Excel documenten on-line te bewerken, gebruik makend van de "Excel Web App". Indien je een Live account hebt, kan je een Excel 2010 bestand plaatsen op je skydrive. Iedereen die toegang heeft tot die Skydrive map, kan vervolgens dat Excel bestand on-line openen en in de browser berwerken. Tevens is het mogelijk om dat Excel bestand te integreren op iedere web pagina.

Thu, 05 Jan 2012 10:25:00 GMT

Creating webpages with Excel Web App mashups

With Excel 2010, Microsoft introduced the possibility to edit Excel documents on-line, using the "Excel Web App". If you have a live account, you can place an Excel 2010 file on your skydrive. Anyone who has access to that skydrive folder can then open that Excel file on-line and edit it in the browser. Moreover, you can also embed that same Excel file on any web page.

Thu, 15 Dec 2011 10:25:00 GMT

Updated article: Installing An Excel Add-in Using Setup Factory

I have updated my article that describes how to use Setup Factory to install an addin. Special thanks to Emiel Nijhuis of www.delegate.nl for suggesting some fixes.

Tue, 22 Nov 2011 06:40:00 GMT

Name manager updated

Name Manager for Excel has been updated. Fixed a small issue with regards to replacing rangenames in VBA code.

Mon, 26 Sep 2011 12:45:00 GMT

New tool: ExportVBAProject

This utility enables you to copy the components from a VBAProject to a single text file. Very useful if you need to compare the VBA code of two Excel files. Use a text compare tool like ExamDiff to compare differences in the exported files.

Thu, 15 Sep 2011 15:45:00 GMT

Nieuwe tool: ExportVBAProject

Met deze utility kan je alle VBA componenten van werkmap A exporteren naar één tekst bestand. Handig als je de inhoud van twee versies van een VBA project wil vergelijken.

Thu, 15 Sep 2011 15:45:00 GMT

Update to Autosafe

I've updated Autosafe so it now also works in 64 bit Excel 2010.

Mon, 29 Aug 2011 11:00:00 GMT

Batchprocessing: how to calculate your model with many input values

I have added an article to my website (courtesy Niek Otten). Introduction of the article: Sometimes you want to apply an existing worksheet calculation to many sets of data rather than just the one case for which it was designed. For example, you developed a worksheet which calculates your pension. It accepts some twenty input variables and generates five output variables. Then your boss demands that you apply that one-time worksheet to 500 employees. Of course you could write some VBA code to do this. But many people hesitate to use VBA and often they are not even allowed to, on their work PC. Fortunately, there is a solution that does not require VBA. Excel has a feature for doing this, the Data, Table command. But it's not well documented. Each time I was asked to do something complex using a Data Table, it took me a while to remember how to do it. So I developed this recipe. It may seem like a lot of steps, but it's actually very straightforward and can be done in minutes.

Thu, 25 Aug 2011 13:05:00 GMT

Name manager updated

Name Manager for Excel has been updated. Fixed a small issue with regards to the larger grid in Excel 2007 and 2010.

Thu, 07 Jul 2011 13:05:00 GMT

Updated article: Declaring API functions in 64 bit Office

I have added a link to a download by Microsoft listing many win64 API declarations.

Thu, 12 May 2011 09:05:00 GMT

Updated article: Declaring API functions in 64 bit Office

I have added a couple of new Windows API function declarations for Office 64 bit to the list.

Thu, 03 Mar 2011 07:15:00 GMT

Update to Flexfind: 64 bit enabled

My free Flexfind tool for Excel has been updated to build 570. Flexfind now also works in 64 bit Excel 2010.

Thu, 17 Feb 2011 07:45:00 GMT

Name manager updated

Name Manager for Excel has been updated. When deleting a name, Name Manager now offers to un-apply the name in your workbook.

Tue, 15 Feb 2011 16:45:00 GMT

Name manager bijgewerkt

Name Manager for Excel is bijgewerkt. Bij verwijderen van bereiknamen worden deze nu op verzoek in je formules omgezet naar hun oorspronkelijke verwijzingen.

Tue, 15 Feb 2011 16:45:00 GMT

Update to Flexfind: Now finds Error values if your Excel is NOT in English

My free Flexfind tool for Excel has been updated to build 569. Flexfind now finds Error values like #NUM! if your Excel is NOT in English.

Mon, 14 Feb 2011 07:45:00 GMT

New page: Pivottable Slicers

Pivottables are one of the most powerful data analysis features Excel has to offer. From version to version, Microsoft have added functionality to this feature. The number of additions and their usefulness differ from version to version of course. Amongst the additions and updates for Excel 2010 are Pivottable Slicers. In this article I'll discuss how you can put slicers to work.

Wed, 12 Jan 2011 13:45:00 GMT

New page: Software reviews

Sometimes I review a piece of software. I decided these deserve a special place on my website, so here is the first one: Setup Factory.

Mon, 03 Jan 2011 07:45:00 GMT

Update to Flexfind: S&R for alt+010

My free Flexfind tool for Excel has been updated to build 568. Flexfind can now handle characters like alt+010.

Tue, 14 Dec 2010 06:35:00 GMT

Name manager updated

Name Manager for Excel has been updated. Fixed a compile error Office 2010 64 bit users were experiencing.

Tue, 23 Nov 2010 08:45:00 GMT

Name manager updated

Name Manager for Excel has been updated. I finally fixed an odd compile error that only happened for a few of my users.

Thu, 18 Nov 2010 05:25:00 GMT

Updated: Query Manager

I have finally gotten round to updating the Query Manager so you can use it to update the connection and commandtext of pivot caches using external data.

Thu, 23 Sep 2010 09:20:00 GMT

A new tool: FollowCellPointer

I have just published a small tool which follows your cell pointer by placing two arrows on top of your sheet pointing to the active cell. Does not change your cell formatting.

Wed, 08 Sep 2010 15:50:00 GMT

een tooltje voor Excel: FollowCellPointer

Ik heb zojuist een tooltje geplaatst, dat je cel aanwijzer makkelijker te vinden maakt door er met een horizontale en vertikale pijl naar te wijzen.

Wed, 08 Sep 2010 15:50:00 GMT

Updated article: Preventing auto_open and Workbook_Open events from running

Seems the methods I described to prevent the workbook_Open event do not always work for Excel 2007.

Thu, 08 Jul 2010 20:00:00 GMT

Name manager version 4.2 released

Name Manager for Excel has been updated to version 4.2 with quite a number of updates.

Thu, 01 Apr 2010 17:50:00 GMT

Name manager version 4.2 gepubliceerd

Name Manager voor Excel, versie 4.2 is gepubliceerd, met aardig wat nieuwe mogelijkheden.

Thu, 01 Apr 2010 17:50:00 GMT

Name manager goes 64 bit!

My free Name Manager for Excel has been updated to build 616 so it now works on 64 bit Excel 2010 too. This means there is a version of Name Manager for all versions of Excel, starting with Excel 97.

Thu, 01 Apr 2010 07:20:00 GMT

Excel opstart problemen pagina bijgewerkt

De pagina is bijgewerkt voor de Excel versies 2007 en 2010.

Mon, 22 Mar 2010 08:40:00 GMT

Importing Text Tiles In An Excel sheet

If you've ever tried to open a text file, you have probably used the Text import wizard. If you have ever opened a CSV file, you have probably noted you can't set up how it gets imported. The text import wizard does not start for these file types. What if you have the situation where you get files with similar structure, which need the same text import settings over and over? How do you import the data from those files into the same worksheet each time, without having to re-define the import settings over and over again? I'll tell you.

Thu, 11 Mar 2010 09:00:00 GMT

Access backup tool updated

I have updated my Access Backup utility so it no longer errors on linked tables. Also, it now copies the relationships too.

Wed, 03 Feb 2010 09:45:00 GMT

Declaring API functions in 64 bit Office

With the introduction of Windows 7 and Office 2010 VBA developers face a new challenge: ensuring their applications work on both 32 bit and 64 bit platforms. This page is meant to become the first stop for anyone who needs the proper syntax for his API declaration statement in Office VBA.

Thu, 28 Jan 2010 12:05:00 GMT

Voorkomen dat auto_open en Workbook_Open events worden uitgevoerd.

Omdat ik software ontwikkelaar ben, komt het regelmatig voor dat ik een Excel bestand wil openen met de macro's ingeschakeld. Tegelijkertijd wil ik daarbij soms voorkomen dat het Workbook_Open event of de Auto_Open macro wordt uitgevoerd. In dit artikel laat ik zien hoe dit in de verschillende Excel versies kan worden gedaan.

Mon, 11 Jan 2010 08:20:00 GMT

Updated article: Registering a User Defined Function with Excel.

To enable showing argument descriptions for Excel User Defined Functions (UDF), we had to go through many hoops and use wizardry and trickery. Excel 2010 has now enabled us to use a plain and simple VBA command to do exactly that. I have updated the article to include a how-to for Excel 2010.

Wed, 06 Jan 2010 06:40:00 GMT

Using controls on worksheets

Apart from input cells chained to cells with formulas, there are other options in Excel to make your spreadsheet model more interactive. You can add option buttons, check boxes and list boxes to your sheet to offer choices to the user. Moreover, you can add scroll bars and spinners to quickly control values in cells. These elements are called controls because they enable your user to control the content of your model. This article shows how to put controls to use in your model.

Tue, 29 Dec 2009 09:15:00 GMT

Preventing auto_open and Workbook_Open events from running

As a fulltime developer I oftentimes open files containing VBA and want to be able to run code. At the same time I sometimes want to prevent Workbook_Open event code or an Auto_Open macro from running. This little article shows you how to achieve that.

Mon, 07 Dec 2009 13:20:00 GMT

Het gebruik van Besturingselementen

Naast invoercellen die zijn gekoppeld aan cellen met formules, beschikt Excel over nog meer mogelijkheden om een werkblad interactief te maken. Zo is het mogelijk om aan een werkblad keuzerondjes, selectievakjes, tekstvakjes en dergelijke toe te voegen. Deze elementen worden ook wel besturingselementen genoemd, omdat ze de gebruiker in staat stellen Excel te "besturen". Dit artikel laat zien hoe deze elementen gebruikt kunnen worden.

Mon, 23 Nov 2009 13:10:00 GMT

Update to Flexfind: S&R in textboxes

My free Flexfind tool for Excel has been updated to build 563. Flexfind can now handle textboxes with more than 255 characters of text.

Tue, 17 Nov 2009 06:35:00 GMT

Update: RefTreeAnalyser (build 1.0.26)

RefTreeAnalyser has been updated. RefTreeAnalyser now does not error out when started whilst editing a cell.

Thu, 05 Nov 2009 10:40:00 GMT

Update: RefTreeAnalyser (build 1.0.25)

RefTreeAnalyser has been updated. It now shows a small message when no references have been found.

Fri, 02 Oct 2009 15:30:00 GMT

Name manager update: bugfix to enable Name Manager to work on Excel 2010

My free Name Manager for Excel has been updated to build 613, with a bugfix related to Excel 2010.

Wed, 30 Sep 2009 15:00:00 GMT

Name manager update: Added the possibility to add local names to each worksheet

My free Name Manager for Excel has been updated to build 610. I have added the possibility to add local names to each worksheet using the Add Names dialog. In addition, Name Manager is now fully Excel 2010 compatible!

Wed, 22 Jul 2009 13:30:00 GMT

Update: RefTreeAnalyser (build 1.0.24)

RefTreeAnalyser has been updated to fix a small bug related to using the stop button.

Fri, 17 Jul 2009 14:55:00 GMT

Name manager update: Some minor bug fixes applied

My free Name Manager for Excel has been updated to build 608. Fixed some minor bugs.

Mon, 13 Jul 2009 07:10:00 GMT

Update to: Using Parameters With Web Queries

Excel provides a very useful option to gather data from websites, called web queries. These have been introduced with Excel 97 and have been further enhanced in the versions released after Excel 97. This article shows how you can setup a web query so that you can make the worksheet dynamically update based on the values in so called parameter cells.

Thu, 09 Jul 2009 08:30:00 GMT

Update to Autosafe

I've updated Autosafe so it stays quiet as long as the system has been used within the last 30 seconds. After 4 skips it will do a save even though you're busy.

Mon, 25 May 2009 08:10:00 GMT

The New Excel 2007 File Format; Adding RibbonX code to an Office OpenXML file using VBA

Previously, I showed how to access and modify existing parts of an Office OpenXML package. This opens up the path for us to add ribbon customisation code to an Office file. For this to happen, a couple of modifications were needed to the code in the class module I showed earlier. Fellow Excel MVP Ken Puls was kind enough to make some modifications to the class module, which I refined a little. The results are summarised in this article.

Mon, 18 May 2009 18:30:00 GMT

The New Excel 2007 File Format; Editing elements in an OpenXML file using VBA

Wouldn't it be useful to be able to edit the contents of an Office 2007 OpenXML file from within VBA? Well, now you can, using the sample code and explanation in this article.

Wed, 06 May 2009 18:00:00 GMT

Update: RefTreeAnalyser (build 1.0.23)

RefTreeAnalyser has been updated to fix a small bug related to protected worksheets.

Mon, 04 May 2009 06:25:00 GMT

Werken met tabellen in Excel 2007

Excel 2007 is de eerste Excel versie in lange tijd die vele vernieuwingen bevat. Eén daarvan is de verbetering in de manier waarop Excel om kan gaan met gegevens tabellen. De functionaliteit (Tabellen genaamd) is in wezen een uitbreiding op de lijsten die Excel 2003 al kent. Dit artikel introduceert deze nieuwe functionaliteit en laat zien hoe het u kan helpen in uw dagelijks werk met Excel.

Tue, 28 Apr 2009 08:10:00 GMT

Koppelingen naar UDFs in Addins herstellen

Excel heeft honderden ingebouwde functies die je helpen bij het doen van allerlei berekeningen. Maar soms is het handiger om een zelfgemaakte functie te bouwen in VBA. Dergelijke functies worden ook wel "User Defined Function" genoemd, UDF. UDF's worden normaal gesproken hetzij in het bestand gezet waarin ze nodig zijn, hetzij in een invoegtoepassing. Er kunnen problemen ontstaan wanneer de lokatie van de invoegtoepassing wordt veranderd, bijvoorbeeld omdat deze in de lokale addin map is geplaatst (deze map is voor iedere gebruiker anders!). Zodra een bestand geopend wordt dat gebruik maakt van de UDF op een systeem met een afwijkend pad naar de invoegtoepassing, zullen de formules die een functie uit de invoegtoepassing gebruiken als resultaat #NAAM! geven. In dit artikel beschijf ik een aantal manieren om deze problemen het hoofd te bieden.

Fri, 24 Apr 2009 11:00:00 GMT

Het nieuwe Excel 2007 bestandsformaat

Excel 2007 (Office 2007) heeft een nieuw bestandsformaat, gebaseerd op wat Microsoft het Open XML formaat noemt. Dit nieuwe formaat geeft ons de mogelijkheid om programmacode te schrijven, die Office 2007 bestanden kan genereren en/of wijzigen, zonder dat Office daarvoor hoeft te zijn geinstalleerd. Bijvoorbeeld op een (web-)server. Alhoewel er behoorlijke documentatie is over dit bestandsformaat, beslaat dit document met de gedetailleerde beschrijvingen van het Open XML formaat ("part 4" op de vermelde pagina) maar liefst 4721 paginas ! Daarom besloot ik een paar basis pagina's te schrijven over hoe men iets met deze Open XML bestanden kan doen.

Wed, 22 Apr 2009 08:15:00 GMT

Update: RefTreeAnalyser (build 1.0.21)

RefTreeAnalyser has been updated with a new feature: The tool now handles Excel 2007 structured references to tables. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Mon, 30 Mar 2009 15:15:00 GMT

Bijgewerkt: RefTreeAnalyser (build 1.0.21)

RefTreeAnalyser is bijgewerkt met een kleine toevoeging: de tool toont nu ook gestructureerde verwijzingen naar Excel 2007 tabellen. Heeft u een licentie? Haal dan deze gratis update op! Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet u wat een nachtmerrie dat kan zijn! Nu is er de RefTreeAnalyser! Met deze tool is het uiterst eenvoudig om erachter te komen hoe een cel aan haar informatie komt en welke andere cellen hun waarde aan deze cel ontlenen.

Mon, 30 Mar 2009 15:15:00 GMT

Name manager update: Added Finnish language

My free Name Manager for Excel has been updated to build 606. No bug fixes, just added the Finnish language.

Sun, 22 Feb 2009 11:30:00 GMT

Update to Fixing Excel problems page

I've added some information on solving Excel trouble caused by corruptions in Excel's registry key.

Wed, 18 Feb 2009 11:50:00 GMT

Excel problemen pagina bijgewerkt

De pagina is bijgewerkt met nieuwe informatie over het oplossen van een register probleem van Excel.

Wed, 18 Feb 2009 11:50:00 GMT

Styles in Excel

This article explains how you can use styles to ease maintenance of your spreadsheet models. Microsoft has made it very easy to dress up your worksheets with all sorts of fill patterns, borders and other frills. Because formatting of cells is often done in an ad-hoc manner, many spreadsheet pages look messy. By consistently using cell styles you will be forced to think about the structure of your work. Religiously using styles may even force people to reconsider the overall structure of the entire spreadsheet model: The quality of the computational model itself may be positively affected. I therefore consider Styles as being underused, underestimated and under exposed.

Thu, 05 Feb 2009 16:30:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has been updated with a new feature: The tool now shows the trace arrows of the currently selected cell. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Thu, 29 Jan 2009 08:25:00 GMT

Bijgewerkt: RefTreeAnalyser

RefTreeAnalyser is bijgewerkt met een kleine toevoeging: de tool toont de verwijzingspijlen van de huidige geselecteerde cel. Heeft u een licentie? Haal dan deze gratis update op! Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet u wat een nachtmerrie dat kan zijn! Nu is er de RefTreeAnalyser! Met deze tool is het uiterst eenvoudig om erachter te komen hoe een cel aan haar informatie komt en welke andere cellen hun waarde aan deze cel ontlenen.

Thu, 29 Jan 2009 08:25:00 GMT

Opmaakprofielen in Excel

Dit artikel laat zien hoe je gebruik kunt maken van Excel's stijlen om het onderhoud aan een spreadsheet te vergemakkelijken. Het is maar al te gemakkelijk om een werkblad te verfraaien met allerlei kleurtjes, kadertjes en andere tierelantijntjes. Omdat deze formatterings werkzaamheden vaak ad-hoc gebeuren, veroorzaakt dit nogal eens een rommelig geheel. Door consistent gebruik te maken van opmaak profielen in plaats van cel voor cel onderdelen van de formattering aan te passen, wordt je gedwongen gestructureerder te werken. Dit artikel laat zien hoe e.e.a. in zijn werk gaat.

Thu, 29 Jan 2009 07:30:00 GMT

Update to Autosafe

I've updated Autosafe to cater for illegal filenames which may result from downloading files. Please note that if you're using build 119, the autoupdate function causes an error. 119 users are advised to download autosafe manually:

Mon, 26 Jan 2009 17:40:00 GMT

Kolom breedtes in een ListBox automatisch aanpassen

Laatst had ik in een project een snelle methode nodig om de inhoud van een matrix aan de gebruiker te tonen. Ik wilde hiervoor geen werkblad gebruiken, maar koos voor een Userform. Dus bedacht ik dat ik een listbox wilde gebruiken waarvan de kolombreedtes zich aan de gegevens zouden aanpassen. Dat bleek helemaal zo eenvoudig nog niet...

Mon, 19 Jan 2009 18:00:00 GMT

Brand new Access tool: backup databases which are in use

My very first Access tool has been published today: Do you have one or more databases which are permanently in use? Then you probably know you can't just copy their files to create a backup of them as they might become corrupt. This database tool lets you schedule backups for an unlimited amount of Access databases. The tool keeps three backup copies of each database it backs up. Access 2000 and up.

Thu, 18 Dec 2008 13:05:00 GMT

Een nieuwe Access tool: backup databases die in gebruik zijn

Heeft u een of meer databases die permanent in gebruik zijn? Dan weet u wellicht, dat u niet zonder meer een backup van deze bestanden kunt maken terwijl ze in gebruik zijn: de kopien kunnen corrupt zijn. Deze database tool geeft de mogelijkheid om een ongelimiteerd aantal databases in een in te stellen frequentie te laten kopieren. De tool houdt drie versies van elke database in stand, voor extra zekerheid.

Thu, 18 Dec 2008 13:05:00 GMT

Update to Autosafe

I've updated Autosafe to fix a small bug in the update process that affected Excel 2007.

Thu, 27 Nov 2008 08:05:00 GMT

XML and Excel

Microsoft Office 2003 Professional was the first Office version that took the XML standard seriously. The XML standard has been devised to ease the markup of data (especially on the web). A well known example of the use of XML are RSS feeds with which one can gather news from web pages. In reality, these so-called RSS-feeds are nothing less than XML files. This article introduces XML and shows some things that can be done with it (specifically in Excel).

Thu, 20 Nov 2008 14:25:00 GMT

Update to Autosafe

I've updated Autosafe to include the Korean language and fixed a small bug that made Autosafe pickup backup copies of other Excel sessions.

Wed, 12 Nov 2008 06:05:00 GMT

5th anniversary and all new website!!

Already 5 years have passed since I founded my company. And I must say those years passed in the blink of an eye. I've never enjoyed my work as much as in these past years. Along with this fifth anniversary comes a new website look and feel. Come and have a look!!

Wed, 05 Nov 2008 19:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has been updated a minor bugfix regarding screen resizing. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Mon, 20 Oct 2008 12:10:00 GMT

Bijgewerkt: RefTreeAnalyser

RefTreeAnalyser is bijgewerkt met een kleine bugfix met betrekking tot het veranderen van de schermgrootte. Heeft u een licentie? Haal dan deze gratis update op! Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet u wat een nachtmerrie dat kan zijn! Nu is er de RefTreeAnalyser! Met deze tool is het uiterst eenvoudig om erachter te komen hoe een cel aan haar informatie komt en welke andere cellen hun waarde aan deze cel ontlenen.

Mon, 20 Oct 2008 12:10:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has been updated a minor bugfix regarding duplicate operators in formulas such as >=. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Thu, 25 Sep 2008 18:44:00 GMT

Name manager update: Fixed a few issues

My free Name Manager for Excel has been updated to build 604. A tiny issue was fixed.

Wed, 17 Sep 2008 11:10:00 GMT

Update to Flexfind: Fixed a few issues

My free Flexfind tool for Excel has been updated to build 560. I've fixed a bug in searching and replacing in chart series.

Mon, 11 Aug 2008 18:45:00 GMT

Fixing Links To UDFs in Addins

Excel has a host of built-in functions to help you do your computations. But sometimes you need to write your own functions using VBA. These functions are called "User Defined Functions" (UDF). UDFs typically are placed in addins. As long as the addin is installed, the UDFs work as expected. You get into trouble when the location of the addin changes, for example because you have distributed the Addin to your co-workers and they have installed it to their local user addin folder (which is different for each user!). As soon as a file which uses the UDF is opened on a system that uses a different addin path, all cells that use your UDF show #NAME! errors. Also, the complete path to the original location of the add-in is shown in each formula: ='C:\data\FixLink2UDF.xla'!UDFDemo(A1,A2). This article describes a couple of ways to avoid/resolve this situation.

Mon, 02 Jun 2008 18:15:00 GMT

Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox

For a project I needed a quick way to display the content of an array to the user. I didn't want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. So I figured I'd put a listbox on a userform and make sure the column widths of the listbox resize with the data I want shown. That proved far from easy...

Wed, 14 May 2008 18:15:00 GMT

Update: Name Manager (version 4.1, build 603)

Updated Name Manager: Fixed a bug: when hidden name is edited, it used to become unhidden. When one adds names and the filter is set to show hidden names, new names are hidden by default.

Tue, 13 May 2008 18:45:00 GMT

Update: Name Manager (version 4.1, build 602)

Updated Name Manager: Fixed a bug in the used names filter avoiding false positives on names which resemble a column reference.

Tue, 13 May 2008 08:00:00 GMT

Update: SetupUtility

Updated SetupUtility: Accounted for the fact the Application.UserLibraryPath does contain a trailing pathseparator, unlike any other path in Excel's object model.

Tue, 06 May 2008 10:55:00 GMT

Update: Name Manager (version 4.1, build 600)

Updated Name Manager: Fixed a bug in the Areas filter.

Wed, 23 Apr 2008 15:45:00 GMT

Update to Flexfind: Improved Userinterface

My free Flexfind tool for Excel has been updated to version 5.3, build 558. I've improved the UI and the selecting of found items.

Fri, 28 Mar 2008 13:45:00 GMT

Update: Name Manager (version 4.1, build 599)

Updated Name Manager: I've Updated the unused names filter to include objects and VBA and fixed a bug affecting Excel 2000 users only.

Fri, 28 Mar 2008 13:45:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has been updated with hotkeys and improved reporting. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Mon, 10 Mar 2008 08:10:00 GMT

Update: Name Manager (version 4.1, build 595)

Updated Name Manager: Fixed a bug regarding editing a name in R1C1 mode and changed the way the create name dialog works.

Wed, 13 Feb 2008 18:15:00 GMT

Update: RefTreeAnalyser

RefTreeAnalyser has been updated with a help file and is now accessible through the cell rightclick menu. Do you have a license? then get this free download to update! Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Wed, 13 Feb 2008 06:10:00 GMT

Update: Name Manager (version 4.1, build 594)

Updated Name Manager: Removed a control on a form that caused compile errors for some users.

Fri, 18 Jan 2008 19:25:00 GMT

New page: Catching Paste Operations

You know the situation: You have carefully setup a workbook with intricate Validation schemes. But then along comes your user and he copies and pastes at will. Result: Validation zapped, workbook structure violated. What to do? The only way I find reliable is to catch all possible paste operations. But this isn't very easy, since there are a zilion ways to paste...

Mon, 17 Dec 2007 18:10:00 GMT

New page: Excel Headlines

Now in one convenient place: the most recent references to articles from what I think are the most important Excel Blogs in the world.

Fri, 07 Dec 2007 18:10:00 GMT

Update: Name Manager (version 4.1, build 590)

Updated Name Manager to add a tiny but very useful toolbar to the VBE, which enables you to select from available range names and paste into your code.

Thu, 06 Dec 2007 18:00:00 GMT

Bijgewerkt: Name Manager (versie 4.1, build 590)

De Name Manager is uitgebreid met een o zo handig toolbartje waarmee je in de Visual Basic Editor een bereiknaam kunt selecteren in in je code laten plakken.

Thu, 06 Dec 2007 18:00:00 GMT

New Tool: RefTreeAnalyser

Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be! Now there is the RefTreeAnalyser! With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze.

Mon, 03 Dec 2007 10:55:00 GMT

Een nieuwe Tool: RefTreeAnalyser

Ooit de logica achter een Excel bestand van iemand anders moeten uitzoeken? Ooit de spaghetti berg aan formule verwijzingen moeten ontwarren? Dan weet u wat een nachtmerrie dat kan zijn.! Nu is er de RefTreeAnalyser! Met deze tool is het uiterst eenvoudig om erachter te komen hoe een cel aan haar informatie komt en welke andere cellen hun waarde aan deze cel ontlenen.

Mon, 03 Dec 2007 10:55:00 GMT

Update to: Working with Tables in Excel 2007

I just learnt that using a table from workbook 1 in workbook 2 requires a special syntax. I have updated the article so it includes this information.

Wed, 14 Nov 2007 07:35:00 GMT

Update to Flexfind: bugfix

My free Flexfind tool for Excel has been updated to build 552. Fixed problems with using wildcard search and replace.

Mon, 08 Oct 2007 14:15:00 GMT

Een artikel op de Nederlandse "Microsoft voor ondernemers" website.

Dit artikel is onlangs (in het Nederlands) geplaatst op de website "Microsoft voor ondernemers". De link naar het artikel op de Microsoft site vindt u op bij het artikel op mijn site.

Fri, 28 Sep 2007 10:37:00 GMT

Published an article on the Dutch Microsoft Company website.

This article of mine was recently published (in Dutch of course) on the Dutch Microsoft website. The link to the MSFT site is mentioned at the top of the article.

Fri, 28 Sep 2007 10:37:00 GMT

Update: Name Manager (build 588)

Updated Name Manager to fix a small bug. Now pivot table source ranges are updated when renaming a name.

Tue, 18 Sep 2007 07:00:00 GMT

Bijgewerkt: Name Manager (build 588)

Name Manager is bijgewerkt naar build 588 waarmee een kleine bug is gefixt. Nu worden de bronbereiken van draaitabellen ook aangepast bij het hernoemen van een bereiknaam.

Tue, 18 Sep 2007 07:00:00 GMT

Update: CopyVBAProject for Excel VBA (build 005)

This utility enables you to copy the components from the VBAProject of workbook A to Workbook B. Updated to build 005: Fixed not copying class modules.

Tue, 11 Sep 2007 15:45:00 GMT

Update to Flexfind: bugfix

My free Flexfind tool for Excel has been updated to build 551. Fixed some problems with searching in protected worksheets.

Wed, 08 Aug 2007 17:30:00 GMT

Update: CopyVBAProject for Excel VBA (build 004)

This utility enables you to copy the components from the VBAProject of workbook A to Workbook B. Updated to build 004: Existing modules are overwritten in stead of added.

Mon, 06 Aug 2007 17:05:00 GMT

Update to AutosafeVBE: bugfix

My free AutosafeVBE for Excel has been updated to build 026. Important fixes for the Excel version are included, so users are recommended to download.

Mon, 06 Aug 2007 07:35:00 GMT

The New Excel 2007 File Format; Changing properties of Form controls

On this page I explain how you can change properties of form controls on worksheets by editing the xml inside an Excel file's internals directly.

Fri, 08 Jun 2007 18:25:00 GMT

New download: CopyVBAProject for Excel VBA

This utility enables you to copy the components from the VBAProject of workbook A to Workbook B.

Fri, 01 Jun 2007 18:25:00 GMT

Update to Flexfind: bugfix

My free Flexfind tool for Excel has been updated to build 550. Important fix: When replacing text in Values, previous builds would also replace in cells with a formula. Build 550 fixes that issue.

Thu, 31 May 2007 09:15:00 GMT

The New Excel 2007 File Format, Working With Worksheet Data In An Excel 2007 File

On this new page I'll explain how you can read and write to a cell on a worksheet by editing the xml inside an Excel file's internals directly.

Thu, 17 May 2007 15:15:00 GMT

Listing an Object's Properties and Methods

If you do some VBA programming regularly, you'll be acquainted with the Object browser, which neatly shows you all objects, properties and methods belonging to any object in Excel (or any other library you have referenced in your VBA project). Whilst this is a tremendous tool to look for information on just a couple of properties I find it not very handy when you e.g. Need to get all of an objects properties into your VBA code. So because I like a challenge I decided to build my own object browser, which is shown to you on this new page.

Mon, 14 May 2007 14:00:00 GMT

Working with Tables in Excel 2007 (VBA)

In "Working with Tables in Excel 2007" I promised to add a page about working with those tables in VBA too. Well, here you go.

Fri, 27 Apr 2007 18:45:00 GMT

Update: Updating an Excel Addin Through the Internet

I have updated this article because I got some reports on problems with Excel 2007.

Mon, 23 Apr 2007 10:20:00 GMT

Excel VBE Multiline Search And Replace.

Sometimes I want to automate the editing of some parts of my VBA code. One thing I wantd to do lately, was search for mutliple of lines of codes (and of course replace them with new lines). I've now released a tool that enables you to do just that!

Thu, 12 Apr 2007 15:30:00 GMT

Books on Excel.

Since I revised an Excel VBA book, I decided it was time to add a page on books on Excel to my website. The page only lists this one book for now, but I intend to add more in the coming weeks.

Tue, 03 Apr 2007 08:30:00 GMT

Installing An Excel Add-in Using Setup Factory.

This article first shows how Excel manages addins in the registry. Then it shows scripts how to do this during a setup routine using the program called Setup Factory. Being an MVP has some benefits. One of them is that some software companies offer Not For Resale (NFR) products to them for free. Of course these companies hope the MVPs will advocate their products. Well, for this one I will do so: Setup Factory. I've started using this tool just a week ago and I must say I'm most impressed with it.

Wed, 21 Mar 2007 09:10:00 GMT

Autosafe Update: Auto-update included.

I've updated Autosafe to include the 'updating of an addin' method I described earlier.

Tue, 20 Mar 2007 13:10:00 GMT

Updating an Excel Addin Through the Internet

If you have created a nice add-in, an updating mechanism is an easy way to ensure your users get any bugfixes you did automatically . This article demonstrates how you can implement this functionality in your addin.

Mon, 19 Feb 2007 09:10:00 GMT

Update to Fixing Excel problems page

I've added some information on troubleshooting startup trouble caused by COM addins.

Fri, 09 Feb 2007 17:40:00 GMT

Pagina bijgewerkt: Excel opstart Problemen oplossen

Toegevoegd is een aantal tips om problemen veroorzaakt door COM invoegtoepassingen te onderzoeken.

Fri, 09 Feb 2007 17:40:00 GMT

Announcing: Release of Autosafe 3.5

Autosafe is now freeware. Autosafe backs up your work in Excel. When you restart Excel after a crash, you're offered to restore backed up copies of your files. You can also restore previous backup copies from your recycle bin to revert back to an older version of your work. This new version of Autosafe will work with long path+filenames (previous versions didn't).

Thu, 01 Feb 2007 09:31:00 GMT

Update to article 'Creating An Add-in From An Excel Macro.'

With the release of Office 2007, everything has changed regarding user interface programming in Excel. I've updated my set of articles on distributing macros today, with special sections on Excel 2007 where appropriate.

Fri, 26 Jan 2007 11:50:00 GMT

Name Manager 4.0: Bugfix

Build 580 of Name Manager fixes a rarely occuring problem which prevented it from loading, showing an "Invalid Picture" error.

Thu, 18 Jan 2007 08:10:00 GMT

Working with Data Tables in Excel 2007

With the release of Excel 2007, Microsoft has introduced a new concept of working with tables of data. This new functionality is (not surprisingly) called "Data Tables". This article introduces you into the concepts of working with Data Tables and shows you how they may help you in your everyday Excel use.

Fri, 12 Jan 2007 13:30:00 GMT

Flexfind for Excel 2007

I've added an Excel 2007 version of Flexfind. Only change: inserts a control on the ribbon for easy access.

Tue, 19 Dec 2006 08:40:00 GMT

Dokken van vensters in de VBE

Als je net zoals ik een VBA programmeur bent, dan vindt je het wellicht ook belangrijk hoe de verschillende vensters van de Visual Basic Editor zijn geplaatst. Soms maakt de VBE er een rommeltje van en het kan op zijn zachtst gezegd een uitdaging zijn om ze weer allemaal op hun plekje te krijgen. In dit artikeltje laat ik je zien hoe je dat kunt doen.

Fri, 15 Dec 2006 15:45:00 GMT

Fixing Docking Of Windows In The VBE

If you're a VBA programmer like me, you're probably picky about your window arrangements in the Visual Basic Editor. Sometimes it messes things up and it can be a challenge to get those windows where you want them. Here are some tips to get things back in order.

Wed, 06 Dec 2006 18:00:00 GMT

Name Manager 4.0: Another Bugfix

Build 577 of Name Manager fixes a small bug related to renaming local names.

Wed, 29 Nov 2006 15:45:00 GMT

Name Manager 4.0 for Excel 2007 RTM: Released

I have uploaded an Excel 2007 RTM version of Build 576 of Name Manager today.

Fri, 24 Nov 2006 10:15:00 GMT

Name Manager 4.0: Another Bugfix

Build 576 of Name Manager fixes a small bug related to use of Name Manager in an Office MUI language situation. Added functionality: delete names by pressing the del key.

Wed, 15 Nov 2006 14:00:00 GMT

Name Manager 4.0: Small Bugfix

Build 575 of Name Manager fixes a small bug related to renaming a name which is not in use.

Sat, 04 Nov 2006 15:04:00 GMT

Announcing: Beta version of Autosafe 3.5

This new version of Autosafe will work with long path+filenames (previous versions didn't).

Fri, 27 Oct 2006 12:15:00 GMT

Aankondiging:: Beta versie van Autosafe 3.5

Deze versie maakt gebruik van Autosafe mogelijk in situaties met lange bestands en padnamen.

Fri, 27 Oct 2006 12:15:00 GMT

Announcing: Name Manager 4.0 for Excel 2007

For those of you who are using and testing Excel 2007 (Beta 2), Name Manager for Excel 2007 is available on this page.

Mon, 18 Sep 2006 10:40:00 GMT

Transposing the Formulas in a Table of Cells

Recently someone asked me if it was possible to transpose a table of cells, but in such a way that the formula of each cell is kept intact. I decided VBA was the way to go and produced a small but very useful little routine for that.

Fri, 15 Sep 2006 18:00:00 GMT

De formules in een tabel transponeren

Recentelijk vroeg mij iemand of het mogelijk is om een tabel met cellen te transponeren, zodanig dat de formule van elke cel intact blijft. Ik besloot dat VBA de aangewezen weg was om dit te bereiken en heb een kleine maar handige subroutine gemaakt die dat doet.

Fri, 15 Sep 2006 18:00:00 GMT

Announcing: Excel Name Manager 4.0 Released

New features: 1. Rename a name. Name Manager now includes a rename option, which will enable you to change the name of a name and have all objects that use that name update too. 2. View where name is in use. A treeview shows all locations where a name is used, including VBA code.

Mon, 12 Jun 2006 18:40:00 GMT

Excel Name Manager 4.0 is nu beschikbaar

Nieuwe mogelijkheden: 1. Hernoem een naam. Name Manager geeft u nu de mogelijkheid om een naam te hernoemen. Hierbij worden alle formules die gebruik maken van die naam ook bijgewerkt, evenals mogelijke objecten (grafieken, besturingselementen e.d.); 2. Toon waar een naam precies in gebruik isinclusief in uw VBA code.

Mon, 12 Jun 2006 18:40:00 GMT

Een bereik laten selecteren door de gebruiker (VBA, Bug in Application.InputBox functie).

De Application.InputBox functie is zeer handig om een bereik door de gebruiker te laten selecteren, waarmee vervolgens in de VBA code verder gewerkt kan worden. Helaas bevat deze functie een bug (all huidige Excel versies hebben deze bug). Wanneer er op het werkblad waarop een bereik wordt geselecteerd voorwaardelijke opmaak is ingesteld waarbij bovendien gebruik is gemaakt van de optie "formule is", dan kan de functie een lege string als resultaat teruggeven.

Tue, 30 May 2006 17:30:00 GMT

New page: NavigatorXL: Business Intelligence with Oracle and Excel Made Easy.

NavigatorXL ends the spreadsheet chaos and smoothens the path for really value-added business intelligence solutions. With NavigatorXL you can: Distribute updated spreadsheets throughout your business organization. Secure your spreadsheets so department managers are only allowed to see their department's data. Combine multiple data sources into one spreadsheet. Combine local spreadsheet with updated budgets with actual data from your corporate system. Collect updated forecast figures entered in a sales pipeline spreadsheet. Create an Excel form (expense report, timesheet...) and collect and share the data centrally.

Sun, 21 May 2006 14:50:00 GMT

Update to Setup utility.

If you have created a nice add-in, a setup utility is an easy way for your users to install your addin. This free utility just needs you to change 4 cells to roll your own setup file. Update: Now automatically removes invalid addins from addin list (courtesy: Richard Reye).

Thu, 11 May 2006 08:45:00 GMT

Getting a range from the user with VBA (Bug in Application.InputBox function)

The Application.InputBox function is very useful to get a range from the user. Unfortunately, this function exposes a bug in Excel (all current versions!). If the sheet on which a (range of) cell(s) is selected contains conditional formatting using the : "Formula Is" option, the function may fail, returning an empty range.The only reliable workaround is to build a userform to request the range from the user, which I have included as a download.

Thu, 04 May 2006 10:30:00 GMT

Update: Excel Name Manager 4.0 Beta new build

I have fixed a couple of bugs in Beta 4 of the Name Manager (build 554).

Thu, 04 May 2006 10:20:00 GMT

Update: Excel Name Manager 4.0 Beta new build

I have fixed a couple of bugs in Beta 4 of the Name Manager (build 550) and added a feature: show a list of all places where a name is in use.

Fri, 28 Apr 2006 10:45:00 GMT

Announcing: Excel Name Manager 4.0 Beta

New feature: Rename a name. Name Manager now includes a rename option, which will enable you to change the name of a name and have all objects that use that name update too. This new feature has yet to be tested thoroughly though, so that is why this version is still in Beta stage. Test drive version 4 and report any problems to me.

Tue, 11 Apr 2006 09:00:00 GMT

XML en Excel 2003

Microsoft Office 2003 Professional is de eerste Office versie die de XML standaard echt serieus neemt. De XML standaard is ingesteld om het markeren van gegevens (met name op het web) te vergemakkelijken. De standaard vindt steeds meer toepassing. Een bekend voorbeeld zijn RSS feeds waarmee men nieuws kan vergaren van internet pagina's. Deze zogeheten RSS-feeds zijn niets anders dan XML bestandjes. Dit artikel geeft een inleiding in wat XML is en wat er (met name in Microsoft Excel) mee gedaan kan worden.

Wed, 05 Apr 2006 07:00:00 GMT

Undo mogelijk maken voor macro's in Excel VBA

In Microsoft Word kan men wijzigingen die door VBA code in een document worden aangebracht standaard ongedaan maken. In Excel is dit helaas niet het geval. Vrijwel alle macro commando's legen de Undo "stack" en de acties zelf kunnen niet meer ongedaan worden gemaakt. Om dit toch mogelijk te maken, moet men code schrijven die: De vorige staat van alles dat gewijzigd gaat worden opslaat; Een routine instelt die uitgevoerd moet worden wanneer de gebruiker voor "ongedaan maken" kiest; Die routine programmeren, die de wijzigingen die door de code zijn uitgevoerd weer ongedaan maakt, in omgekeerde volgorde. In dit artikel wordt gedemonstreerd hoe twee klasse modules kunnen worden ingezet om een (min of meer) generieke "undo handler" te bouwen, welke in elk Excel VBA project kan worden ingezet.

Tue, 04 Apr 2006 08:20:00 GMT

Update to AutosafeVBE

A heads-up to all VBA developers. I've just updated AutosafeVBE, the utility that backups your VBA projects. Now handles up to 9999 generations!

Thu, 23 Mar 2006 18:40:00 GMT

Creating An Undo Handler To Undo Changes Done By Excel VBA

Unlike Word, changes made to an Excel workbook by using VBA cannot be undone easily. One has to write code that: 1. Stores the previous state of anything that (possibly) needs to be undone. 2. Sets a sub to be run when the user selects undo. 3. Write that subroutine, which reverses the changes last made by your code. In this article I will demonstrate how one can use two class modules to create a (more or less) generic undo handler which one can plug into any project.

Thu, 09 Mar 2006 06:50:00 GMT

Interactivity on jkp-ads.com

I have recently added a database to my site. Now I am learning classic ASP and VBScript (I know, why not .NET?) to use this database and put some interactivity on my site. Take a look! Some articles now have a set of stars at their final page with which you can rate them.

Fri, 24 Feb 2006 19:10:00 GMT

Excel VBA: Registering a User Defined Function with Excel.

When one writes a User Defined Function in Excel VBA, this function appears in the function wizard under the category "Custom". It is possible to change the function category by changing the "macro properties" of the UDF. Unfortunately, VBA does not allow specifying descriptions for the UDFs arguments. One can do this using the old XLM REGISTER function in conjunction with the ExecuteExcel4Macro function from within VBA. This function only accepts 255 characters or less, insufficient for UDFs with more than just one or two arguments. This article describes how this can be overcome, using an ancient XLM macro sheet together with some trickery invented by Laurent Longre.

Fri, 17 Feb 2006 08:20:00 GMT

Excel utility: Watching a cell way off to the right.

When working with Excel worksheets with a lot of used columns, it would be easy if one could have a way to show the content of a column on the same row in a window. This new WatchOtherCell utility does just that.

Thu, 09 Feb 2006 14:20:00 GMT

Using Parameters With Web Queries

Excel provides a very useful option to gather data from websites, called web queries. These have been introduced with Excel 97 and have been further enhanced in the versions released after Excel 97. This article shows how you can setup a web query so that you can make the worksheet dynamically update based on the values in so called parameter cells.

Tue, 03 Jan 2006 20:00:00 GMT

Macro in Excel Stops After A Workbook.Open Command

Sometimes Excel VBA behaves unexpectedly. Here is an example: You are running code that is meant to open one or more files using the Workbooks.Open command. As soon as you hold down the shift key when this command is being processed, macro execution stops and your program is terminated entirely. This will even happen if you are e.g. editing an email message in Outlook whilst Excel VBA is processing the code in the background.

Fri, 11 Nov 2005 12:30:00 GMT

Formules voorzien van een foutcontrole

Het gebeurt regelmatig, dat ik een bereik met formules heb dat op zich goed werkt, maar dat een foutcontrole nodig heeft, bijvoorbeeld om delen door nul te voorkomen. Dit artikeltje toont wat VBA code om de formules in een reeks cellen te converteren zodat ze een foutcontrole krijgen.

Mon, 31 Oct 2005 12:30:00 GMT

Excel-macro's geschikt maken voor anderen.

Dit artikel is nu volledig in het Nederlands beschikbaar!!! Beschrijving: Excel is een van de meest gebruikte toepassingen in het bedrijfsleven. Het pakket staat bol van de standaard functies. Daarnaast biedt het zoals bekend de mogelijkheid taken te automatiseren via macro's geschreven in VBA. Veel gebruikers starten met het opnemen van macro's, komen vervolgens tot de ontdekking dat de macro recorder geen code oplevert die algemeen toepasbaar is en starten zo zelf met het programmeren. Er komt soms een moment, waarop de gebruiker een macro heeft ontwikkeld die anderen ook graag zouden willen gebruiken. Dat is het moment dat een dergelijk macro zal moeten worden omgezet naar een voor anderen bruikbare utility. Dit artikel geeft een overzicht van de zaken die daarbij aan bod kunnen komen.

Tue, 25 Oct 2005 13:30:00 GMT

Beheersen wanneer een event wordt verwerkt of niet

Events zijn een krachtig hulpmiddel bij het programmeren met Excel. Events maken het mogelijk te reageren op acties van de gebruiker zoals het bewerken van een cel of het klikken van de knop Afdrukken. Wanneer een applicatie gebruik maakt van events, dan is het ook vaak nodig de controle te hebben over het feit of de code in het event wel of niet wordt uitgevoerd (bijvoorbeeld om te voorkomen dat de event code in een oneindige lus geraakt of om programmacode de mogelijkheid te geven acties uit te voeren die het event voorkomt). Dit artikel toont hoe u events onder controle krijgt.

Fri, 07 Oct 2005 17:50:00 GMT

Control When Events Are Handled

Events are a powerful aspect of Excel programming. They enable you to make your application respond to user actions such as entering data into cells or clicking the print button. If your application uses events, you will probably also need to be able to control whether or not an event executes its code or not (e.g. to avoid event looping or to enable your code to do things you are preventing your user to do through the user interface). This article shows a method to gain fine control over which event fires and which does not.

Wed, 14 Sep 2005 08:30:00 GMT

Excel-macro's geschikt maken voor anderen.

Excel is een van de meest gebruikte toepassingen in het bedrijfsleven. Het pakket staat bol van de standaard functies. Daarnaast biedt het zoals bekend de mogelijkheid taken te automatiseren via macro's geschreven in VBA. Veel gebruikers starten met het opnemen van macro's, komen vervolgens tot de ontdekking dat de macro recorder geen code oplevert die algemeen toepasbaar is en starten zo zelf met het programmeren. Er komt soms een moment, waarop de gebruiker een macro heeft ontwikkeld die anderen ook graag zouden willen gebruiken. Dat is het moment dat een dergelijk macro zal moeten worden omgezet naar een voor anderen bruikbare utility. Dit artikel geeft een overzicht van de zaken die daarbij aan bod kunnen komen.

Tue, 23 Aug 2005 18:50:00 GMT

Wrapping Formulas In An Error Test

Oftentimes I have a range filled with formulas that as such work correctly, but need an error checking mechanism. For example to account for cells that are empty. This article shows some code to achieve that. But there is more. I plan to add functionality as we get along.

Tue, 19 Jul 2005 20:40:00 GMT

Range Names in Excel

In Excel you can give a range of cells a name. When you do that, you can use this name instead of the address to point to that range. In general it is easier to remember a name than a range address of the start and end of a range of cells. Using names has a couple of advantages: ranges are easier to find, formulas are simpler to understand and maintenance of the spreadsheet model becomes more reliable. Furthermore, some things in Excel can only be achieved by using defined names. But much more is possible with defined names than just naming a range of cells. Because you can also put a formula into a name, a whole world of possibilities opens up! Even more so, since you can also put the old Excel 4 macro functions to use in a defined name. This enables you to do things normally only possible using VBA.

Wed, 6 Jul 2005 20:00:00 GMT

Bereiknamen in Excel

In Excel is het mogelijk een bereik van cellen een naam te geven. Wordt dat gedaan, dan kan voortaan deze naam gebruikt worden om naar dat bereik te verwijzen, in plaats van het adres. Over het algemeen is een naam van een bereik makkelijker te onthouden dan het adres van de begin- en eindcel van een bereik. Het gebruik van namen heeft een aantal voordelen: bereiken zijn eenvoudiger terug te vinden, formules zijn makkelijker te begrijpen, enzovoorts. Verder zijn er zaken in Excel die alleen mogelijk zijn door een bereik eerst een naam te geven. Maar er kan veel meer met namen in Excel. Er kunnen ook formules in gebruikt worden en dat opent een wereld van mogelijkheden. Sterker nog, omdat tevens de oude Excel 4 macro functies in een gedefinieerde naam mogen worden toegepast zijn dingen mogelijk die normaal gesproken alleen via een VBA macro kunnen worden gerealiseerd. Dit artikel is reeds eerder in het Office magazine (nummer 21, april 2004) verschenen.

Tue, 28 Jun 2005 09:40:00 GMT

Toon minder nieuws