Excel : Copying formulas (with) constraints

Written by Ingmar Verheij on May 8th, 2011. Posted in Office

Microsoft Excel is a spreadsheet program that contains one or more worksheets. Each worksheet contains a bunch of cells which are located by a row (1,2,3,etc) and a column (A,B,C,etc).


Each cell can contain data or a formula. With a formula your able to transform the data from other cells to whatever you may need. You’ll probably want to re-use the formula in different rows, columns or worksheets.

Install SCOM 2007R2 on SQL 2008R2 (including reporting server)

Written by Ingmar Verheij on February 21st, 2011. Posted in Microsoft SQL, Operations Manager

When installing the Microsoft System Center Operations Manager (SCOM) 2007 R2 database on a Microsoft SQL Server 2008 R2 the installation failes because a prerequisite is not met:

This is caused by an outdated installer which doesn’t recoginize SQL 2008R2. Altough installing on SQL 2005 / 2008 will prevent this message there is an alternative.

Excel 2010 crashes on Save(as) / Macro

Written by Ingmar Verheij on February 15th, 2011. Posted in Office

After working multiple days on an Excel worksheet with lots a data, charts en Macro’s the worksheet somehow crashes today. Altough I haven’t found out what iniated the problem (maybe the installation of Adobe Reader X?) I have found a “solution” to the problem.

First of all the symptoms.
After opening an Excel 2010 worksheet, with the Macros enabled (“Enable Content”), the worksheet can’t be saved. Saving the worksheet, or clicking on the Macros button (on the Developer tab), results in a crashing worksheet.

In the event log the followin error is logged:
Faulting application name: EXCEL.EXE, version: 14.0.4756.1000, time stamp: 0x4b9c0870
Faulting module name: VBE7.DLL, version:, time stamp: 0x4b7b2131
Exception code: 0xc0000005
Fault offset: 0x0000000000220b24
Faulting process id: 0x186c
Faulting application start time: 0x01cbcce7fe8ef29f
Faulting application path: C:Program FilesMicrosoft OfficeOffice14EXCEL.EXE
Report Id: 46c04576-38db-11e0-9560-8697dfeafdc5

Since the error only occurs when Macros (or VBA) is enabled, and the error references VBE7.DLL, I suspected the error to be in the VBA area.

Change driveletter of CD-rom

Written by Ingmar Verheij on September 16th, 2010. Posted in Deployment

In a deployment using Altiris (or any other deployment utility) it is common to change driveletters. Especially when servers are reinstalled once in a while, you probably encounter problems doing so using diskpart.
Diskpart is the utility supplied with Windows by Microsoft which enables you to manage you disks, partitions and volumes. One limitation is, however, that you’re unable to select a specific drive using filters. For instance a CD-rom drive.
In an initial deployment you know how many disks there are and how many volumes. Because these are static you can create the diskpart script easily by specifying the disk ID or volume ID, which is numbered in the order of presence.
However, when you redeploy that same server this might be changed. If you’ve added a disk (or formatted it) the order of presence might be changed and the script will fail to execute the way you expected it.

(No more) support for Windows Server 2003 R2

Written by Ingmar Verheij on July 12th, 2010. Posted in No category

As of tomorrow, 7/14/2010, the mainstream support for Windows Server 2003 R2 is retired. This applies to all versions (Standard, Enterprise, Datacenter, etc., 32-bit and 64-bit).
For Business and Development software, like Windows Server products, the support gets extended for an additional 5 years. This “Extended support phase” will end on 7/14/2015.

The good thing about the extended support phase is that security updates and paid support (including pay-per-incident Premier and Essential support) remain available. The same thing applies to the self-help online support such as knowledge base articles and online information.