Microsoft Office Development and Consultancy

Excel

2007 Changes

WORKSHEET FUNCTIONS

All the Analysis-ToolPak functions are now standard worksheet functions and are available without having to install the Analysis-ToolPak add-in.

DATA ANALYSIS

The add-in is still available and needs to be loaded if you want to access the Data Analysis options.

This can be accessed from (Data tab, Data Analysis group)

SS

VBA CODE

VBA code to call these functions has changed. The file location.

Needs to be re-written

There location has moved.