Most Valuable Professional

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

Subscribe to our mailing list

* indicates required
Newsletter Archive

File crashes Excel!!

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


Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Downloads
Deze pagina in het Nederlands



Some of the files on this page are also available at Stephen Bullen's website.

Excel versions

These files should all work in Excel 97, 2000, XP, 2003, 2007, 2010 and 2013, unless stated otherwise. For some downloads a dedicated version for Excel 2007/2010/2013 is available.


Do you like any of these tools? 

Excel add-ins and workbooks

Name of download Description and download link


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!

Name Manager

The Name Manager An excellent utility to manage defined names in your workbooks.


Flexfind eases searching and replacing throughout an entire workbook. Also enables you to search and replace strings in objects such as headers and footers, chart titles, buttons and many, many more.

Autosafe (Build 137, 27 Jan 2015, downloaded: 45376 times)

New in Autosafe: Autosafe keeps saving even if Excel is running in the background.

Version 3.5 of Autosafe enables use in environments with long paths/filenames. The standard Autosave (note the spelling) utility that ships with Excel just saves workbooks at a set interval, overwriting the file on disk. This is not very convenient if you planned to leave the master file intact and save the changed workbook using a different filename. It also does nothing to simplify recovery of unsaved/changed documents after a system crash. This Autosafe utility creates copies of open workbooks at regular intervals in a separate (user-selectable) directory. It does not overwrite the master file(s), that is up to the user to do, using normal methods. As soon as a workbook is closed the backup copy is deleted from the backup directory. If an abnormal termination of Excel occurs, the backup copies remain on disk, and Autosafe finds them the next time Excel is started and presents recovery options to the user.
Autosafe comes with an autoupdate function which checks for updates every week. Includes the following languages: English, Dansk, Deutsch, Espa˝ol, Franšais, Indonesia, Italiano, Nederlands, Norsk, Hrvatski, Slovenščina, Korean, Русский (Russian), Lithuanian and Hungarian.

The previous version is still available:   (13 January 2003, 228k, downloaded: 7828 times) Note that this one shows a nag screen on networked computers.

Autosafe does not work on a Mac.

GoBack (8 April 2015, downloaded: 10526 times) Version 1.0 build 009.

Sometimes one has to edit a large workbook, with many worksheets. This tiny utility keeps a record of the ranges you have visited and gives you the opportunity to return to previous selections using two hot keys: control-alt-p to go to a previous selection and control-alt-n to go to the next. It also creates a toolbar with a dropdown to select a previous selection and  to disable/enable the utility.

Now updated with ribbon user interface.

FollowCellPointer (10 February 2015, downloaded: 12271 times) Version 1.0 build 009.

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 formatting and has an option to preserve the undo stack.

SheetTools (04 May 2015, downloaded: 794 times) Version 1.0 build 001.

This is the file that accompanies my article on how to build an Excel add-in

CloseAllWorkbooksAndQuit (01 Oct 2015, downloaded: 179 times) Version 1.0 build 001.

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

HeaderFooter (28 January 2008, downloaded: 11005 times) Version 1.0 build 006.

Managing headers and footers in Excel can be a drag. This little tool helps you to change headers and footers in your files easily by means of a toolbar that shows dropdown/edit boxes in which you can type the header/footer codes directly or select them from the list of currently present header/footer codes in your file.

SetupUtility (Updated May 5, 2008, downloaded: 13204 times)

If you have created a nice add-in (see this article how to do that), 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.


UpdateAnAddin.xls (Updated February 19, 2007, downloaded: 15437 times)

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

ShowTableOnUserform (14 May 2008, downloaded: 8825 times)

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... See this article on how it works.

FixLinks2UDF (02 June 2008, downloaded: 5274 times)

A demo file that handles #Name! errors for workbooks that use UDFs that reside in an add-in. See this article on how that works.

QueryManager (Build 017, 23 September 2010, downloaded: 14153 times)

This utility has been developed together with Dick Kusleika. It eases the editing of queries and Pivottable connections. One can:

1. Edit the SQL string and the connect string of queries and PivotCaches

2. Add parameters

3. Change the path to the data source

All in a single dialog.

AutosafeVBE (build 026, 6 Aug 2007, downloaded: 18651 times)

This utility makes backup copies of VBA components to a user-defined directory. It keeps a user selectable number of copies of each component. It thus keeps a number of generations of your code as your work progresses, enabling you to return to a previous copy when things go wrong. Because it just exports the VBA components, it is unobtrusive because this process is relatively fast compared to saving your workbook or document. Excel and Word version included!!

Non linear Least Squares (12 Apr 2012, downloaded: 9954 times) Fit complex functions like y=exp(a.x).sin(x) + b to data using Least squares

ExcelVBEMultilineSR (Version 1.0, Build 004, 27 Nov 2008, downloaded: 6982 times)

This utility enables you to do Search and Replace operations in the Visual Basic Editor of Excel. What is special about this tool is that you can search for multiple lines of code and replace with multiple lines of code.

CopyVBAProject (Version 1.0, Build 007, 05 Oct 2007, downloaded: 7790 times)

This utility enables you to copy the components from the VBAProject of workbook A to Workbook B
Build 004: Existing modules are removed before copying.

ExportVBAProject (Version 1.0, Build 005, 1 Sep 2015, downloaded: 3851 times)

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 this handy tool to compare differences in the exported files: ExamDiff

PerformanceClass (Version 1.0, Build 001, 20 Aug 2014, downloaded: 1364 times)

This example file demonstrates the use of a class module to measure performance of your VBA code. See A VBA performance class for an explanation.

TrustedDocumentManager (Version 1.0, Build 001, 10 oct 2013, downloaded: 1656 times)

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 the possibility to remove files which no longer exist from the list.

Only available for Excel 2010 and up!

ObjectLister (Version 1.0, Build 003, 1 October 2008, downloaded: 11097 times) Lists objects, properties and methods of the selected object and enables you to quickly build code that uses many properties of an object. See the ObjectLister page for more information.


An All-VBA (MSforms) treeview control that makes the common controls treeview obsolete. Works in all Office versions as of Office 2000, including 64 bits and MAC office.

The Excel download contains most of the documentation (on the tabs of the workbook), so I recommend you to at least download the Excel version.

Download the treeview sample workbook (build 024, 20 May 2013, downloaded 15773 times)

Download the treeview sample Word document (build 024, 20 May 2013, downloaded 4268 times)

Download the treeview sample Access database (build 024, 20 May 2013, downloaded 13143 times)

See the accompanying article: An MSForms (all VBA) treeview

VBA driven circular references (11 February 2015, downloaded 554 times)

This file demonstrates the use of VBA to control circulare reference calculations. See: Working with Circular references in Excel, Properly setting up circular references

AutoChrt (2 March 2015, downloaded: 19666 times)

Automates the process of creating graphs from database-like datasets, where you need to chart various columns against each other in x-y scatter charts to determine relationships between them. It consists of a sheet where to copy the data into and a sheet that holds the chart and some spinner-buttons to control which data are charted.

ChartAnEquation (May 1, 2005, downloaded: 11106 times)

Demonstrates a method to chart a mathematical equation using just defined names.
See this article for an explanation.

ControlHandler     (17 June 2005, downloaded: 8794 times)

Demonstrates a method to handle the events for multiple controls on a worksheet using a single class module. See this article for an explanation.

ControlLister (10-7-2014, downloaded: 3199 times)

Tool that lists all controls on your userforms on a worksheet. Includes code to rebuild the userforms from the table. Note: does not handle userforms with multipage controls very well!

CatchPasteDemo (17 Dec 2007, downloaded: 7666 times)

Demonstrates how to intercept paste operations in a workbook to prevent users from wrecking your validation. The download contains two workbooks; one for Excel 2003 and earlier, the other for Excel 2007 and 2010. See this article for an explanation.

UndoHandler     (8 March  2006, downloaded: 9824 times)

Demonstrates a method to enable the user to undo changes made by your VBA code. See this article for an explanation.

WatchOtherCell     (18 September 2012, downloaded: 8977 times)

This workbook simplifies looking at data in a sheet with a lot of columns. It shows the value of a cell on the same row in a column one can enter in a textbox. This way you can scroll all over the sheet and always (e.g.) have the value of a cell in column BE in view. Start the watcher by opening the file and using its entry in the Tools menu.

GetARange     (4 May 2006, downloaded: 12151 times)

This workbook demonstrates a bug in the VBA Application.InputBox function as described here. The workbook also contains a userform and sample code to work around that bug.

EditOpenXML    (5 September 2011, downloaded: 8686 times)

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 this demo file. Find a full description here.

ModelessFormOnTop (26 November 2012, downloaded: 2626 times)

Excel 2013 now has a SDI as opposed to the MDI previous Excel versions have. This file demonstrates how to keep a modeless userform on top of the Excel 2013 window.  Find a full description here.

Arg2Name     (8 February 2001, downloaded: 16629 times)

This workbook demonstrates a trick to pass (range) arguments to defined name formula's. As published in David Hagers' EEE #9, available from John Walkenbach's web site. See the Excel names page.

xlMenuFunDict   (29 Jan 2003, downloaded: 20180 times)

International versions of Office have the menu system in their local language. Also the Excel worksheet functions are (mostly) listed in local language. This complicates communication with the users with such a version. To aid in this process a utility has been devised that creates and shows a translation list of the Excel built-in command bars and controls and the Excel worksheet functions. This workbook can also list command bars of other Office software packages. It thus enables the international user who is using a different language version of Excel to quickly find translations for sequences of menu commands and function names.


Showing last 8 comments of 269 in total (Show All Comments):


Comment by: Jan Karel Pieterse (9/26/2015 10:17:28 PM)

Hi m.Susanto,

Perhaps this article gives you sufficient ideas?


Comment by: sam (10/1/2015 6:37:34 PM)

Hi Jan Karel
Re : Quit Excel Add-in

Try the following in Excel 2013
Go to customise the Quick Access Toolbar
Choose all commands
Type E
It will take you to buttons that begin with E
Sroll donw further and there is a button called EXIT
Add it to the QAT
(If you are a keyboarder ALT+F+X works as well)


Comment by: Jan Karel Pieterse (10/2/2015 2:59:46 PM)

Hi Sam,

I fell into a trap many many people fall into; 80 percent of all feature requests Microsoft gets for new features for Excel are already in the product. So was this one :-)


Comment by: gerdami (11/2/2015 12:27:18 PM)

Feedback on Autosafe.

Just donated!

When restoring a workbook, relative hyperlinks to other workbooks have a wrong path to C:\Autosafe-excel\, i.e. Autosafe path folder.

Would be great if the routine could simply replace the hyperlink paths to "".


Comment by: Jan Karel Pieterse (11/2/2015 2:26:51 PM)

Hi gerdami,

Thank you for both the donation and the suggestion for improvement!


Comment by: nilesh (11/8/2015 8:41:24 AM)

i overwrite my file.
how can i backup old data and 3 day before file in excel.
pleas send me email    


Comment by: Jan Karel Pieterse (11/10/2015 5:23:20 PM)

Hi Nilesh,

Right-click the file and choose Properties. Click the Previous versions tab.


Comment by: gerdami (11/20/2015 12:25:23 PM)

Autosafe settings interval reset to 1 min.

I set this to 10' but after a while, it is reset to 1 min.
It happens on 2 different computers:
- Windows7, Excel 2010
- XP, Excel 2003 (do not smile !)
Autosafe 3.5, Build 138.


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here:

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].