Welcome to the website of JKP Application Development Services

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 two tools: GithubVBAExporter and FollowCellPointer

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

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

Wed, 14 Dec 2022 14:30:00 GMT

Video: Office Script And Power Automate Demo

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

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

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

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

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

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

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

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

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: Excel tips & tricks

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

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

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

Fri, 27 May 2022 13:15:00 GMT

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

Wed, 25 May 2022 15:45:00 GMT

Updated: Excel tips & tricks

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

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

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

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

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

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

Office Script, The basics updated

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

Mon, 06 Dec 2021 14:35:00 GMT

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

I've updated the tool with some UI improvements.

Mon, 15 Nov 2021 10:15:00 GMT

A tombola, built in Excel

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

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

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

Wed, 20 Oct 2021 09:45:00 GMT

Office Script, Called from Power automate

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

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

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

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

Tue, 17 Aug 2021 17:20:00 GMT

Importing Text Tiles In An Excel sheet

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

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

Updated: Github VBA exporter

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

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

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

Video: Smart Macro Recording

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

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

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

I've fixed two bugs in the tool.

Fri, 10 Apr 2020 15:00:00 GMT

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

Webinar recording: Working with tables in Microsoft Excel

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

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

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

The Excel VBA Masterclass

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

Mon, 13 Jan 2020 13:30:00 GMT

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

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

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

Updated article: Working with Circular references in Excel

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

Wed, 30 Oct 2019 16:15:00 GMT

I have updated the page on VBA driven circular reference calculations

Tue, 22 Oct 2019 11:45:00 GMT

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: Pivottable Slicers, Synchronizing slicers

I've enabled the Compare2Tables tool to work on 64 bit Excel.

Tue, 03 Sep 2019 14:50:00 GMT

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

RefTreeAnalyser 2.0 has just been updated. I have improved the Check Formulas interface.

Tue, 06 Aug 2019 16:19:00 GMT

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

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

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

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

A new tool: Compare Two Tables

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

I've added a tool (in beta!!) to my download section called Compare2Tables.

Mon, 25 Feb 2019 17:00:00 GMT

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

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

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

Mon, 12 Nov 2018 15:15:00 GMT

The Excel VBA Masterclass

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

I'm scheduling a new run of my Excel VBA Masterclass soon.

Wed, 31 Oct 2018 13:45:00 GMT

The Ljubljana Excel VBA Masterclass

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

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

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

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

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

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

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

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: Privacy Beleid JKP-ADS

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

Thu, 14 Jun 2018 19:05:00 GMT

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

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

Thu, 24 May 2018 16:15:00 GMT

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

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

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

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

Mon, 09 Apr 2018 17:00:00 GMT

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

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

Wed, 15 Nov 2017 17:30:00 GMT

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

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

RefTreeAnalyser 2.0 has just been updated. Improved the formula report

Mon, 18 Sep 2017 15:30:00 GMT

Co-authoring in Office 365

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

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

Access backup tool updated

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

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

Wed, 10 May 2017 08:15:00 GMT

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

Our Amsterdam Excel Summit was great

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

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

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

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

Sun, 19 Feb 2017 13:20:00 GMT

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

Sat, 18 Feb 2017 19:10:00 GMT

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

The Amsterdam Excel Summit 2017: Registration is open

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

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

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

RefTreeAnalyser 2.0 has just been updated. Fixed three bugs.

Wed, 14 Dec 2016 20:55:00 GMT

a Simple Inventory System, built in Excel

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

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

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

An MSForms (all VBA) listgrid.

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

Thu, 16 Jun 2016 15:50:00 GMT

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

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

Updated: Flexfind. Improved selecting objects.

Thu, 21 Apr 2016 08:50:00 GMT

New training: Excel VBA Mafsterclass

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

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

Mon, 29 Feb 2016 07:15:00 GMT

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

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

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

Tue, 19 Jan 2016 08:25:00 GMT

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

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

Tool to help close all Excel windows

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

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

Summer sale at jkp-ads.com

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

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

New Excel article: Building an Add-in for Excel

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

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

The Amsterdam Excel Summit 2015: Registration is now open!

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

Tue, 10 Feb 2015 17:20:00 GMT

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

Celebrating my MVP award: Discount offer

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

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

Commenting has been fixed

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 to Flexfind: Bugfix regarding replacing dates

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

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

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

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

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

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

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

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

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

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 for Excel has been updated. Improved window handling for Excel 2013.

Mon, 09 Sep 2013 17:30:00 GMT

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 for Excel has been updated. Added Italian user interface language.

Wed, 21 Aug 2013 16:10:00 GMT

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

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

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

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

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

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

New article and download: 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

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: RefTreeAnalyser (build 1.0.31)

I've updated Autosafe with new translations for German.

Tue, 29 Jan 2013 15:30:00 GMT

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

Updated article: Declaring API functions in 64 bit Office

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

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

Working with Circular references in Excel

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

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

New tool: ExportVBAProject

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

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

Batchprocessing: how to calculate your model with many input values

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

Mon, 29 Aug 2011 11:00:00 GMT

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

Updated article: Declaring API functions in 64 bit Office

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

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

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

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

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 for Excel has been updated. Fixed a compile error Office 2010 64 bit users were experiencing.

Tue, 23 Nov 2010 08:45:00 GMT

A new tool: FollowCellPointer

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

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

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

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

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

Bijgewerkt: 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

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

Kolom breedtes in een ListBox automatisch aanpassen

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

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

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

5th anniversary and all new website!!

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

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

Bijgewerkt: 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

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

Name manager update: Fixed a few issues

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

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: Name Manager (version 4.1, build 595)

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

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