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

image

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.

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: 7.0.15.90, 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
Faulting module path: C:PROGRA~1COMMON~1MICROS~1VBAVBA7VBE7.DLL
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.

Enable VBA/Macro’s in Excel 2010

Written by Ingmar Verheij on June 14th, 2010. Posted in Office

If you want to use VBA (Visual Basic for Applications) or use Macro’s in Excel 2010 you need to access the Developer view. In Excel 2007 this was a checkbox setting in the general options, but this has changed with Excel 2010.

In order to enable the Developer tab in the ribbon you should follow the following steps:
1) Open the File menu on the left side of the screen

Prevent online content in Visio

Written by Ingmar Verheij on March 11th, 2010. Posted in Office

When the first document in Visio 2003 is opened / created using templates from Microsoft Office Online (which is default), the user gets a question about updating links from an online source.

If you wish to prevent this message you can set the following registry keys:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0CommonInternet]
"UseOnlineContent"=dword:00000000
"ShowSpotlight"=dword:00000000

Ingmar Verheij

Donate