Open an Excel 2007 workbook in Excel versions 97-2003

How to Open Excel 2007 Workbook in Excel versions 97-2003

Before one can open Microsoft Office Excel 2007 workbooks in an earlier version of Excel, you can either use the earlier binary file format (.xls) to save them or use the new XML-based file format (.xlsx) to exchange the workbooks between different versions of Excel. To save a copy that is fully compatible with Excel 97-2003, take the following steps:

1. In Excel 2007, open the workbook that you want to save in Excel 97-2003 format.
2. Click the Microsoft Office Button , and then point to the arrow next to Save As.
3. Under Save a copy of the document, click Excel 97-2003 Workbook.
4. Click Save.
5. The file will be saved in the Excel 97 - Excel 2003 Binary file format (.xls or BIFF8) so that it can be opened in versions of Excel 97 through Excel 2003.
6. Important. You can also save a workbook to Excel 5.0/95 binary file format (BIFF5).
7. Repeat steps 1 – 2 above.
8. Under Save As type box, click Excel Binary Workbook.
9. Click Save.

 

 

You will be able open the workbook in that version of Excel, but Excel 2007 formatting and features will be lost.

Download and install updates and converters for an earlier version of Excel
On the computer that has the earlier version of Excel installed, do one of the following:

1. Download the 2007 Microsoft Office system Compatibility Pack for Excel from the Microsoft Office Downloads web site (http://r.office.microsoft.com/r/rlidAWSContentRedir?AssetID) and install the updates and converters that are needed to open Office Excel 2007 workbooks.
2. All Excel 2007 workbooks that you open after installing the updates and converters will automatically be converted so that you can edit and save them without having to upgrade to Excel 2007.Office Excel 2007-specific features and formatting may not be displayed in the earlier version of Excel, but they are still available when the workbook is saved and then re-opened in Excel 2007.

 

 

What is Microsoft Excel?

What can I do with Microsoft Excel?

As the use of Microsoft Excel continuous to pose hindrances to many current and potential users, who could have been able to use the business analysis tool to simplify and automate many of their daily business data analysis, this blog "Use of MS Ecel" i shere to elucidate the software usage and unravel the mystery behind its applauded success as a business analysis tool.

In this, written in easy to understand language on Microsoft Office Excel, I will show you everything there is to know about Microsoft Excel, if you what you are looking for is not posted, you can ask for a a comment and answere will be provided, such that you will be able handle your data analysis with utmost ease and confidence. Theis blog is for both old and new users of the MS Excel. It demonstrated most of Excel's functions and features that a financial professional can use to make his/her job more efficient. The blog does not discuss Visual Basic for Applications (VBA), but instead focuses on Excel features that non-programmers can deploy.

 

 

A basic knowledge of Excel will be an added advantage to your data alalysis and tabulation work, so a;ways visit this blog to learn about how MS Excel can make your job easier. After studying the illustrations in this blog and taking all exercises, you should have enough knowledge to tackle all spreadsheet related problems with current and previous versions of Microsoft Office Excel and you can always refer back to this blog www.usingmsexcel.blogspot.com anytime.

I particularly made effort to use simple language and illustrations, out of long years of experience in the use of the application package, to explain many of the difficulties surrounding the use of the software; especially as new edition come with new features.

Microsoft Office Excel is a great computer software that is widely used throughout the financial industry. MS Excel is an invaluable tool for portfolio managers, traders and accountants. Billion dollar portfolios and positions can be managed and traded using Excel spreadsheets. Management reports and risk management tools can be created and run in this application. In a nutshell, Microsoft Excel has created incredible efficiencies in the finance and accounting industries. In a new results-oriented user interface, the new editions of Microsoft Office Excel provide powerful tools and features that you can use to analyze, share, and manage your data with ease.

 

 

Users of the earlier versions will still find many of the functions explained in this blog very useful in using their earlier versions. If you already know where to find command to execute operations in an earlier version, all other procedures explained in this blog are the same. The syntax of every formula remains the same, while many of the formatting options are equally the same.

It is my belief that the success of a business analyst and a business planner depends largely on his/her ability to keep track of business-situation analysis and acute data analysis and recording. Since Microsoft Excel has many features and functions that can add value and be used to create great efficiencies, this blog is the best companion for every business/financial analyst. And one of the best ways to learn about and master the features and functions in the software is to visit this blog regularlywith utmost seriousness and attention. Finally, having learnt them, don't forget about them as they can save you hours of frustration when reconciling data.

 

Moses Ighedo

Lagos, Nigeria