+ Reply to Thread
Results 1 to 4 of 4

Opening an excel 2007 file in excel 2013

  1. #1
    Registered User
    Join Date
    02-02-2006
    Location
    Sydney . Australia
    MS-Off Ver
    2007 and 2013
    Posts
    98

    Opening an excel 2007 file in excel 2013

    I have a spreadsheet created in Excel 2007 and want to open it in Excel 2013 in a new Windows 10 computer. But I get the message ; "We found a problem with some content in Excel 2013, Do you want us to recover as much as we can ? If you trust the source of the workbook, click " YES" .
    Clicking "YES" , the spreadsheet opens with some features missing , mainly the conditional formatting which is completely lost.
    Any help will be much appreciated.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    Re: Opening an excel 2007 file in excel 2013

    There were some changes made to the CF rules (mostly ones using formulas) in 2010 (I think), so it sounds like your rules are incompatible and will need to be recreated.
    Rory

  3. #3
    Registered User
    Join Date
    02-02-2006
    Location
    Sydney . Australia
    MS-Off Ver
    2007 and 2013
    Posts
    98

    Re: Opening an excel 2007 file in excel 2013

    Could you please explain what the " CF rules " are ? I have no idea what CF means.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    Re: Opening an excel 2007 file in excel 2013

    CF = Conditional Formatting.

+ 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. Opening 2007 file in 2013 loses all conditional formatting, Why?
    By mgerada in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-09-2021, 05:56 AM
  2. Opening an excel 2007 file in excel 2013
    By Michael6 in forum Excel General
    Replies: 5
    Last Post: 12-25-2019, 07:34 AM
  3. Opening XLSM files created in Excel 2013 with Excel 2007
    By wfsteadman in forum Excel General
    Replies: 1
    Last Post: 02-09-2017, 09:20 AM
  4. Replies: 1
    Last Post: 09-03-2015, 12:48 AM
  5. Replies: 6
    Last Post: 03-19-2015, 04:12 AM
  6. Excel 2013 Crashing on opening a XLSM file
    By Wongadob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2014, 05:10 AM
  7. Opening Excel File Crashes. Last opened in 2 windows. 2013
    By bowbalitic in forum Excel General
    Replies: 0
    Last Post: 10-03-2014, 12:08 AM

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