Office 2003 to 2010 File Migration Strategies - How to avoid Duplicate files XLS and XLSX, DOC and DOCX, etc.

Posted on 2012-08-31
Last Modified: 2012-09-01
It seems a difficult task to migrate from 2003 to 2010 without having to manage a lot of duplicate files (i.e. XLS and XLSX formats).  I'm looking for suggestions, strategies and tips to avoid these redundancies.
Question by:brothertruffle880
    LVL 13

    Assisted Solution

    You can convert all the documents in bulk to .xlsx.

    Here is a good tutorial for it, it explains it to convert it to office 2007, but office 2010 is the same.
    LVL 11

    Accepted Solution

    I'd be careful with converting xls files to xlsx.

    1. Macro's:

    xls files with macros must of course be saved to xlsm.

    2. Links:

    About 10 to 20 percent of all Excel files tend to have links to other Excel files. If you convert the xls files to xlsx and then remove the xls files, all links will be broken. OTOH if you leave the original xls files in place, the links will soon be pointing to outdated files if people only work in the xlsx/xlsm files. And people will start working on old copies (the xls files) by accident.

    If you want to bite the bullit and bulk-convert xls files, you need a tool that can do that AND a tool that can restore all links afterwards.

    Some more links:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Suggested Solutions

    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

    760 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

    8 Experts available now in Live!

    Get 1:1 Help Now