Solved

Converting Excel 2003 files to 2010

Posted on 2012-03-20
1
740 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

705 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