Microsoft Office Tutorials and References

In Depth Information

**Preparing Your Spreadsheet for Excel 2007**

Saving Files

Figure 14-17:

Inside every .xlsx

file lurks a number

of compressed files,

each with different

information. For

example, separate files

store printer settings,

styles, the name of

the person who

created the document,

the composition

of your workbook,

and each individual

worksheet.

Most of the time, you don’t need to think about Excel’s file format. You can just

create your spreadsheets, save them, and let Excel take care of the rest. The only time

you need to stop and think twice is when you need to share your work with other,

less fortunate people who have older versions of Excel, such as Excel 2003. You’ll

learn how to deal with this challenge in the following sections.

Tip:
Don’t use the .xlsb format unless you’ve tried it out and find it really does give better performance

for one of your spreadsheets. Usually, .xlsx and .xlsb are just as fast. And remember, the only time you’ll

see any improvement is when you’re loading or saving a file. Once your spreadsheet is open in Excel,

everything else (like scrolling around and performing calculations) happens at the same speed.

Preparing Your Spreadsheet for Excel 2007

As you’ve just learned, Excel 2007 uses the same .xlsx file format as Excel 2010. That

means that an Excel 2010 fan can exchange files with an Excel 2007 devotee, and

there won’t be any technical problems.

However, there are still a few issues that can trip you up when sharing spreadsheets

between Excel 2010 and Excel 2007. For example, Excel 2010 introduces a few new

high-powered formula functions, such as RANK.AVG. If you write a calculation that

uses this function in Excel 2010, it won’t work when someone else opens the

spreadsheet in Excel 2007. Instead of seeing the numeric result that you saw, they’ll see an

error code mixed in with the rest of the spreadsheet data.