Subscribe in a readerWeb Changes
Last 20 changes to this site (in reverse chronological order, both Dutch and English updates are shown):
| 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 |
| Nieuw artikel: 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 |
| New article: Creating webpages with Excel Web App mashups With Excel 2010, Microsoft introduced the possibility to edit Excel documents on-line, using the "Excel Web App". If you have a live account, you can place an Excel 2010 file on your skydrive. Anyone who has access to that skydrive folder can then open that Excel file on-line and edit it in the browser. Moreover, you can also embed that same Excel file on any web page. Thu, 15 Dec 2011 10:25:00 GMT |
| Updated article: Installing An Excel Add-in Using Setup Factory I have updated my article that describes how to use Setup Factory to install an addin. Special thanks to Emiel Nijhuis of www.delegate.nl for suggesting some fixes. Tue, 22 Nov 2011 06:40:00 GMT |
| Name manager updated Name Manager for Excel has been updated. Fixed a small issue with regards to replacing rangenames in VBA code. Mon, 26 Sep 2011 12:45:00 GMT |
| New tool: ExportVBAProject This utility enables you to copy the components from a VBAProject to a single text file. Very useful if you need to compare the VBA code of two Excel files. Use a text compare tool like ExamDiff to compare differences in the exported files. Thu, 15 Sep 2011 15:45:00 GMT |
| Nieuwe tool: ExportVBAProject Met deze utility kan je alle VBA componenten van werkmap A exporteren naar één tekst bestand. Handig als je de inhoud van twee versies van een VBA project wil vergelijken. Thu, 15 Sep 2011 15:45:00 GMT |
| Update to Autosafe I've updated Autosafe so it now also works in 64 bit Excel 2010. Mon, 29 Aug 2011 11:00:00 GMT |
| New article: Batchprocessing: how to calculate your model with many input values I have added a new article to my website (courtesy Niek Otten). Introduction of the article: Sometimes you want to apply an existing worksheet calculation to many sets of data rather than just the one case for which it was designed. For example, you developed a worksheet which calculates your pension. It accepts some twenty input variables and generates five output variables. Then your boss demands that you apply that one-time worksheet to 500 employees. Of course you could write some VBA code to do this. But many people hesitate to use VBA and often they are not even allowed to, on their work PC. Fortunately, there is a solution that does not require VBA. Excel has a feature for doing this, the Data, Table command. But it's not well documented. Each time I was asked to do something complex using a Data Table, it took me a while to remember how to do it. So I developed this recipe. It may seem like a lot of steps, but it's actually very straightforward and can be done in minutes. Thu, 25 Aug 2011 13:05:00 GMT |
| Name manager updated Name Manager for Excel has been updated. Fixed a small issue with regards to the larger grid in Excel 2007 and 2010. Thu, 07 Jul 2011 13:05:00 GMT |
| Updated article: Declaring API functions in 64 bit Office I have added a link to a download by Microsoft listing many win64 API declarations. Thu, 12 May 2011 09:05:00 GMT |
| Updated article: Declaring API functions in 64 bit Office I have added a couple of new Windows API function declarations for Office 64 bit to the list. Thu, 03 Mar 2011 07:15:00 GMT |
| Update to Flexfind: 64 bit enabled My free Flexfind tool for Excel has been updated to build 570. Flexfind now also works in 64 bit Excel 2010. Thu, 17 Feb 2011 07:45:00 GMT |
| Name manager updated Name Manager for Excel has been updated. When deleting a name, Name Manager now offers to un-apply the name in your workbook. Tue, 15 Feb 2011 16:45:00 GMT |
| Name manager bijgewerkt Name Manager for Excel is bijgewerkt. Bij verwijderen van bereiknamen worden deze nu op verzoek in je formules omgezet naar hun oorspronkelijke verwijzingen. Tue, 15 Feb 2011 16:45:00 GMT |
| Update to Flexfind: Now finds Error values if your Excel is NOT in English My free Flexfind tool for Excel has been updated to build 569. Flexfind now finds Error values like #NUM! if your Excel is NOT in English. Mon, 14 Feb 2011 07:45:00 GMT |
| New page: Pivottable Slicers Pivottables are one of the most powerful data analysis features Excel has to offer. From version to version, Microsoft have added functionality to this feature. The number of additions and their usefulness differ from version to version of course. Amongst the additions and updates for Excel 2010 are Pivottable Slicers. In this article I'll discuss how you can put slicers to work. Wed, 12 Jan 2011 13:45:00 GMT |
| New page: Software reviews Sometimes I review a piece of software. I decided these deserve a special place on my website, so here is the first one: Setup Factory. Mon, 03 Jan 2011 07:45:00 GMT |
| Update to Flexfind: S&R for alt+010 My free Flexfind tool for Excel has been updated to build 568. Flexfind can now handle characters like alt+010. Tue, 14 Dec 2010 06:35:00 GMT |
| Name manager updated Name Manager for Excel has been updated. Fixed a compile error Office 2010 64 bit users were experiencing. Tue, 23 Nov 2010 08:45:00 GMT |
