Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel 2003 visual basic intermediate course - excel vs excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Excel 2007 v's Excel 2003

excel 2003 visual basic intermediate course - Excel 2007 v's Excel 2003

ResolvedVersion Standard

Katie has attended:
Excel Advanced course

Excel 2007 v's Excel 2003

If I create workbooks in Excel 2003 and a consolidation spreadsheet which consolidates all the workbooks, will this still work when we convert to Excel 2007? Are there any implications that I need to consider when converting to Excel 2007?

RE: Excel 2007 v's Excel 2003

Hi Katie,

Consolidations still work in version 2007. Just remember you can not use new 2007 files on a 2003 machine.

If you happen to save 2007 files as old versions, i.e. 97-2003 compatility format, you will lose 2007 features (e.g. design colour theme).

Take a look at this link to find your way in Excel 2007:
www.stl-training.co.ukhttp://office.microsoft.com/en-gb/excel/HA101491511033.aspx?pid=CH100648241033[/url]

Regards,

Katie

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.