Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Accessing Old Excel Data.

Accessing Old Excel Data

by Allen Wyatt
(last updated February 11, 2017)

If you have used computers for some time, you have accumulated quite a bit of data over the years. Unfortunately, not all that data is accessible any more. I have very old spreadsheet data stored in Multiplan files, and if I search around a bit longer, I can probably find some disks containing VisiCalc information.

Accessing information stored in old formats can be a big problem. If you update your computer every couple of years—hardware and software—there is a very good chance that you have old data that is essentially lost because you can no longer load it into a program.

There are several approaches you can take if you need to access older data. First, you can install the older versions of the software on your system (if you have the software) and then save the data files in some "exchange" format. For instance, you can save old Multiplan or early Excel information in SYLK format, which can then be read into newer versions of Excel.

Second, you can search through the Microsoft Knowledge Base for information on doing conversions. For instance, when I searched through the Knowledge Base for "Multiplan," I was able to find several pertinent articles that discussed different ways to update information for use with recent versions of Excel. The Microsoft Knowledge Base is available online at this URL:

http://support.microsoft.com/

Third, you could contact a user in your community who has the older version of the software and use their computer to do the upgrade. Many times you can find such users through a local user's group or through a computer store that sells used computer systems.

Finally, there are companies that specialize in doing data conversions. You can search on the Web for such companies and get quotes for updating your data.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1973) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Accessing Old Excel Data.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Adding Drop Shadows

Want your shapes to really "pop" off the page? Add a drop shadow to them, as described in this tip.

Discover More

Conditionally Making a Sound

Need to have a sound played if a certain condition is met? It is rather easy to do if you use a user-defined function to ...

Discover More

Finding Text Not Using a Particular Font

Word makes it easy to find text that uses a particular font or font characteristics. What it doesn't do is make it easy to ...

Discover More

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!

MORE EXCELTIPS (MENU)

Counting the Times a Worksheet is Used

Do you need to know how many times a worksheet has been used? Excel doesn't track that information, but you can develop some ...

Discover More

Determining Your Serial Number

The serial number assigned to your copy of Excel is valuable. It allows you to get support and is necessary for some ...

Discover More

Disabling Excel's Help System

The Help system built into Excel can be quite a lifesaver when you need to find that quick tidbit that is slipping your mind. ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share