+ Reply to Thread
Results 1 to 20 of 20

.XLS file won't convert properly to .XLSX

  1. #1
    Registered User
    Join Date
    04-13-2015
    Location
    Fanwood, NJ
    MS-Off Ver
    2003
    Posts
    18

    .XLS file won't convert properly to .XLSX

    I have a heavily formatted worksheet created in Excel 2003 under an older Windows (Win 98?). Now that I have Excel 2016 and Win10, I want to convert it to XLSX and pin it to the Excel jumplist. But no matter what I do, it comes up as something like "X10000014.XLS (Read-Only) [Compatibility mode]"

    I have tried loading the XLS file and using file convert. I have also tried creating a new blank worksheet in Excel 2016, saving that, then cutting and pasting the data from the XLS file into it. Neither works.

    How do I get this to work?

  2. #2
    Registered User
    Join Date
    04-13-2015
    Location
    Fanwood, NJ
    MS-Off Ver
    2003
    Posts
    18

    Re: .XLS file won't convert properly to .XLSX

    I should add that whenever I click on one of these "converted" files to open it, I first get a message "There was a problem sending the command to the program"

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: .XLS file won't convert properly to .XLSX

    What do you mean by 'convert'

    After opening the .xls file have you used Save As picking the .xlsx format in the Type box
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    04-13-2015
    Location
    Fanwood, NJ
    MS-Off Ver
    2003
    Posts
    18

    Re: .XLS file won't convert properly to .XLSX

    I should add that whenever I click on one of these "converted" files to open it, I first get a message "There was a problem sending the command to the program"

    "Save as xlsx" doesn't do it. "Convert" means clicking File / Info / Convert.

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: .XLS file won't convert properly to .XLSX

    I don't see anything about 'convert' in File...Info. Can you clarify.

    What does happen when you open the original .xls file and then pick File Save As?

    Upload the file here to see if we can save it as a .xlsx.

  6. #6
    Registered User
    Join Date
    04-13-2015
    Location
    Fanwood, NJ
    MS-Off Ver
    2003
    Posts
    18

    Re: .XLS file won't convert properly to .XLSX

    1) In Excel 2016, when I open an XLS, click File, and hen Info, I get, among other things, a square with an Excel icon and the word "convert," just to the left of the note about Compatibility Mode. I'm not sure how to post an attachment, or I'd send a screen shot.

    2) When I try File Save As, the file gets the XLSX extension but still opens in compatibility mode.

    3) The file is 56 KB -- is that OK? How do I upload it? And I'll have to delete two columns of confidential info from that file.

  7. #7
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: .XLS file won't convert properly to .XLSX

    To upload a file, click 'Go Advanced' under the reply box then scroll down to 'Manage Attachments'.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  8. #8
    Registered User
    Join Date
    04-13-2015
    Location
    Fanwood, NJ
    MS-Off Ver
    2003
    Posts
    18

    Re: .XLS file won't convert properly to .XLSX

    Screenshot with convert button attached (I hope)
    Attached Images Attached Images

  9. #9
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: .XLS file won't convert properly to .XLSX

    Why not post the workbook?

    You can remove any sensitive data -- or all the data, for that matter.
    Last edited by shg; 01-22-2017 at 05:06 PM.
    Entia non sunt multiplicanda sine necessitate

  10. #10
    Registered User
    Join Date
    04-13-2015
    Location
    Fanwood, NJ
    MS-Off Ver
    2003
    Posts
    18

    Re: .XLS file won't convert properly to .XLSX

    Here's the redacted file
    Attached Files Attached Files

  11. #11
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: .XLS file won't convert properly to .XLSX

    It opens fine for me in Excel 2010, not in Compatibility mode.

  12. #12
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: .XLS file won't convert properly to .XLSX

    Quote Originally Posted by shg View Post
    It opens fine for me in Excel 2010, not in Compatibility mode.
    ...me too

  13. #13
    Registered User
    Join Date
    04-13-2015
    Location
    Fanwood, NJ
    MS-Off Ver
    2003
    Posts
    18

    Re: .XLS file won't convert properly to .XLSX

    Has anyone tried my file in Excel 2016?

  14. #14
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: .XLS file won't convert properly to .XLSX

    I've not tried it in 2016 but have opened it in a browser using Microsoft Online. The Online version of online is more restrictive than native Excel so I would have expected that if there were any systematic problems with the file that Excel online would have found problems.

    Are you opening the file from either a local folder or a folder on your network as opposed to opening the file from a link in an email. I've found that opening files from emails sometimes give problems.

  15. #15
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: .XLS file won't convert properly to .XLSX

    Opens fine for me in 2016

  16. #16
    Registered User
    Join Date
    04-13-2015
    Location
    Fanwood, NJ
    MS-Off Ver
    2003
    Posts
    18

    Re: .XLS file won't convert properly to .XLSX

    I'm loading it from a local folder. Other files in that folder converted just fine.

    If it opens in someone else's Excel 2016, there must be a problem with my system--but only with this file. Any suggestions?

  17. #17
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: .XLS file won't convert properly to .XLSX

    Maybe get someone else to save it with a new name? Here's your file from your post above - I just changed the fill of A4:A6 to red and resaved with a new name. When you open this, do you get the same problem as before?
    Attached Files Attached Files

  18. #18
    Registered User
    Join Date
    04-13-2015
    Location
    Fanwood, NJ
    MS-Off Ver
    2003
    Posts
    18

    Re: .XLS file won't convert properly to .XLSX

    Checking the revised file, I get the same results -- first "there was a problem sending the result to the program" then, after some seconds, it opens up in compatibility mode with a number as its filename.

  19. #19
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: .XLS file won't convert properly to .XLSX

    Quote Originally Posted by oldmaven View Post
    Has anyone tried my file in Excel 2016?
    Yes, I have, and I dont see any "compat" message/note/anywhere either
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  20. #20
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: .XLS file won't convert properly to .XLSX

    I saved it as .xlsb, see that changes anything?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with code to convert xls to xlsx and continue with xlsx file
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2016, 11:47 AM
  2. [SOLVED] Macro to convert Xls file format to Xlsx
    By meus in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-06-2015, 04:42 AM
  3. [SOLVED] convert xlsx to csv and save to file directory
    By shaz0503 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-27-2014, 07:19 PM
  4. Convert a TXT in XLSX or XLSB without opening the file (VBA)
    By mortphil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-20-2014, 08:27 AM
  5. convert .iqy file to .xlsx file using macro
    By gourishjoshi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2013, 02:51 PM
  6. How to convert a file to xlsx
    By Raner in forum Excel General
    Replies: 2
    Last Post: 12-15-2011, 03:27 PM
  7. Replies: 1
    Last Post: 06-25-2007, 09:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1