Excel File Conversions

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?

 

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.

 

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.

 

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.