Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    XL07 Creates New File as XLS in Compatibility Mode

    When I create a new file with CTRL+N the file created is in old XLS format. If I click on File-New-Blank Workbook-Create, Excel then grenerates an XLSX.

    How do I get the the keyboard shorcut to generate the new format?

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    If you change your default save mode to xlsx, then new files will be automatically created in the new file type. You will then have to remember to "save backwards" to save in the old xls type.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Excel Options - Save - Save Workbooks - Save files in this format: is already set to Excel Workbook (*.xlsx)

    is there some other setting which I need to change?

Posting Permissions

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