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.
 
Search JabSto ::




Custom Search