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

training+excel+microsoft - excel file

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training+excel+microsoft - Excel 2007 - File compatibility between 2007 and previous versio

training+excel+microsoft - Excel 2007 - File compatibility between 2007 and previous versio

ResolvedVersion Standard

Excel 2007 - File compatibility between 2007 and previous versio

Hi

I am benefiting a lot by using NEW Exciting features of Excel 2007 but I want to share my files with people who don't have 2007 yet.
Will they be able to view the data teh same way as I am viewing it?
What features will be lost if other previous version users were to open my file created in 2007?

RE: Excel 2007 - File compatibility between 2007 and previous ve

Hi Thanks for posting your question!

Excel 2007 is fairly new and there are some confusions which are unclear to some of the users.

You can save create a file in 2007 but you do have the option of saving it in 2003 or earlier formats.
All you have to do is to choose Excel 97-2003 from the save as type in the save as dialog box.

If you have used any feutres that not not available in earlier version compatibilty checker dialog box will appear notifying you which features will be lost categorising it by significant loss and minor loss.

If you want to keep a copy for yourself to be used in 2007 then it is recommended that you save the file as a 2007 first in teh appropriate location and then save the same file as an Excel 97-2003 format.

tip: If you happen to save the file in Excel 97-2003 format most of the time tyhen it is advised that you:
- Click on the Office Button on the Top left corner and choose Excel Options.
- Click on the Save on the left hand bar in the dialog box
- You can then choose Excel 97- 2003 from the save files in this format in the save workbooks section!!

Hope this helps and makes things clear!!

Kind Reagrds

Rajeev

RE: Excel 2007 - File compatibility between 2007 and previous ve

This is a really good forum post, with lots of useful information.

Thanks Rajeev, and keep up the good work!

Rich

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

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.33 secs.