Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Western NY, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have worksheets created with Excel, perhaps as far back as Excel 4. They were last saved in Excel 2003, I believe in 2003 file format. When I try to save them using 2007 I get "[file name].xls cannot be saved in the current format. To save your changes, click OK, then save it as the latest format."

    I made no changes. I simply opened the file and hit save. This only happens to some files. I am trying to find a common denominator.

  2. #2
    2 Star Lounger
    Join Date
    Jun 2010
    Location
    philippines
    Posts
    185
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Cecil View Post
    I have worksheets created with Excel, perhaps as far back as Excel 4. They were last saved in Excel 2003, I believe in 2003 file format. When I try to save them using 2007 I get "[file name].xls cannot be saved in the current format. To save your changes, click OK, then save it as the latest format."

    I made no changes. I simply opened the file and hit save. This only happens to some files. I am trying to find a common denominator.
    this is mainly due to compatibility issues. please read this
    http://office.microsoft.com/en-us/ex...010077561.aspx
    thanks and enjoy

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I'd suspect that the problem ones were originally saved with Excel 5/95 compatibility.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Western NY, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by rory View Post
    I'd suspect that the problem ones were originally saved with Excel 5/95 compatibility.
    I believe you got it right, Rory. Further (but I am not sure yet), It only seems to be those with Excel 5 macros saved in compatibility mode.

    Thanks to both of you for the help.

Posting Permissions

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