1. Welcome Guest! In order to create a new topic or reply to an existing one, you must register first. It is easy and free. Click here to sign up now!.
    Dismiss Notice

Excel File Conversions

Discussion in 'General Software' started by buzzman, Jan 25, 2011.

  1. buzzman

    buzzman

    Joined:
    Mar 7, 2010
    Messages:
    10
    Location:
    Phoenix
    Operating System:
    Windows 7
    I have hundreds of Excel spreadsheets with .xls file formats since they are 1997-2003 worksheets. Many of these spreadsheets have macros but are still .xls formats. I recently purchased Microsoft Office 2010 and am now using the new version of Excel. The new version appears to use .xlsx for worksheets and .xlsm for macro enabled worksheets.

    Is there an easy way to convert all my spreadsheets from .xls formats to .xlsm formats. I would probably prefer to just have all my spreadsheets in .xlsm format even if there are no macros so all my files have the same format unless there is a good reason not to do this.

    My other major concern is that many of my spreadsheets have links that specifically list files with .xls formats. What is the best way to update all the links in all my spreadsheets so the link will list the new file format of .xlsm so it can find the file?
     
  2. BeeCeeBee

    BeeCeeBee ADMINISTRATOR IN MEMORY

    Joined:
    Apr 20, 2009
    Messages:
    7,201
    Location:
    New Jersey "Stronger than the Storm"
    Operating System:
    Windows 7
    Welcome back buzzman! We have a number of members who are really good with Office products. I am not one of them. I am sure there will be someone to help you within a reasonable period of time.
     
  3. allheart55 (Cindy E)

    allheart55 (Cindy E) Administrator Administrator

    Joined:
    Jun 11, 2009
    Messages:
    10,617
    Location:
    Pennsylvania
    Operating System:
    Windows 10
    Computer Brand or Motherboard:
    ASUS M4A77TD AM3 AMD 770 ATX AMD
    CPU:
    AMD Phenom II X6 1090T-Thuban 3.2GHz
    Memory:
    Crucial-DDR3 SDRAM 1333-8GB
    Hard Drive:
    WD Caviar Black SE HDD 640 GB - WD Caviar Black SE HDD 500 GB
    Graphics Card:
    Sapphire Radeon HD-7870 2GB
    Power Supply:
    CORSAIR CMPSU-750W
    Hi Buzzman,

    I believe Office 2010 is backwards compatible and should automatically
    recognize any previous files already created in Office.
     
  4. buzzman

    buzzman

    Joined:
    Mar 7, 2010
    Messages:
    10
    Location:
    Phoenix
    Operating System:
    Windows 7
    Yes I can open the files but I still do want to convert all my spreadsheets to 2010 format .xlsm or .xlsx for various reasons. The file size is much smaller when I convert it to 2010 format and it is much quicker to open and save large files in 2010 format. It is also annoying to get these messages about file formats and compatibility when saving files. So I prefer to just convert all my spreadsheets to .xlsm format and also want the links within the files to reference files with .xlsm rather than .xls. Thanks.
     
  5. allheart55 (Cindy E)

    allheart55 (Cindy E) Administrator Administrator

    Joined:
    Jun 11, 2009
    Messages:
    10,617
    Location:
    Pennsylvania
    Operating System:
    Windows 10
    Computer Brand or Motherboard:
    ASUS M4A77TD AM3 AMD 770 ATX AMD
    CPU:
    AMD Phenom II X6 1090T-Thuban 3.2GHz
    Memory:
    Crucial-DDR3 SDRAM 1333-8GB
    Hard Drive:
    WD Caviar Black SE HDD 640 GB - WD Caviar Black SE HDD 500 GB
    Graphics Card:
    Sapphire Radeon HD-7870 2GB
    Power Supply:
    CORSAIR CMPSU-750W
  6. Alan

    Alan Inactive

    Joined:
    Sep 8, 2009
    Messages:
    561
    Or if you using the Excel files, choose Save As and select xlsx or xlsm as required. If you want to batch convert them, follow allhearts link.
     

Share This Page