exce+training - excel and excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » exce+training - Excel 2003 and Excel 2007

exce+training - Excel 2003 and Excel 2007

resolvedResolved · Low Priority · Version Standard

Neil has attended:
Excel Advanced course

Excel 2003 and Excel 2007

Hi,

I am having some problems with the different versions of Excel - I am using 2007 while my colleagues are using 2003.

One early problem I have noticed is that the graphs functionality is different in 2007.

What is the best way to manage the difference? Can a saving preference be permanently set, so as to minimise problems?

Thanks and regards,
Neil

RE: Excel 2003 and Excel 2007

Hi Neil, Thanks for the post, in answer to your question; I agree there are quite a number of differences between graphs in 2007 and 2003, however you can save your workbooks as 97 - 2003 compatible, look in your File Save As dialog box and check the Save As Type drop down option. Note that the new 2007 features will not be available in 2003 or earlier versions. I hope that helps, regards Pete.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips


Server loaded in 0.1 secs.