Solved

Converting Excel 2003 files to 2010

Posted on 2012-03-20
1
732 Views
Last Modified: 2012-03-20
I recently changed from Office 2003 to 2010.  I have thousands of Excel files in the 2003 format.  When I open them now I’m saving them to the 2010 format, then I delete the old file.  This is time consuming, and I’m wondering if there’s a way to convert all files at once.  My Office 2010 is on a new computer, so I did a clean install, not an upgrade.  I’m still using my old computer with Office 2003, and I’d prefer not to upgrade that one to Office 2010.
0
Comment
Question by:GregMcKim
1 Comment
 
LVL 12

Accepted Solution

by:
Alan3285 earned 500 total points
ID: 37745411
Hi Greg,

Why convert them?

Excel 2010 will happily work with older Excel files, so just leave them as .xls format.

If / when you ever open a file, you can always re-save as Excel 2010 format (.xlsx) then.

In fact, that way, your Excel 2003 machine(s) can then also access the (unconverted) files too.  You can install an update to Excel 2003 that allows them to read newer files, but if you leave them in .xls format, you don't need to worry about that.

HTH,

Alan.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now