+ Reply to Thread
Results 1 to 6 of 6

2003/2007/2010 compatibility puzzle!

  1. #1
    Registered User
    Join Date
    12-06-2013
    Location
    Basingstoke, Hampshire
    MS-Off Ver
    Excel 2010
    Posts
    7

    2003/2007/2010 compatibility puzzle!

    Hi,
    New member Mike Basingstoke here.
    Got a problem since I upgraded (yesterday) to Office 2010 whereby a customer who uses Excel2003 who could share my files created in Excel 2007 now gets #NAME? errors. The functions that seem to be triggering this are nothing esoteric - just tame stuff like IFERROR and INDEX and MATCH. I've researched this in help and on Google extensively but I cannot find a fix. Can anyone help? Much obliged. Mike

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: 2003/2007/2010 compatibility puzzle!

    Hi and welcome to the forum

    IFERROR function is not compatible with Excel 2003. INDEX and MATCH should be fine. IFERROR can be replace with IF(ISERROR( combination.
    Last edited by AlKey; 12-06-2013 at 07:46 AM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    12-06-2013
    Location
    Basingstoke, Hampshire
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: 2003/2007/2010 compatibility puzzle!

    Thanks AlKey for a very fast response. I had IFERROR in the spreadsheet for ages and it seemed to cause no problems. I only recenly added a price lookup table that is accessed by INDEX & MATCH (my first time using these after reading a lot of advice that says they work better than LOOKUP) and I've got 609 occurences of significant loss of functionality ! I may just have to copy the cell contents and paste as values. I only upgraded 'cos I'm going on a VBA course in 2 weeks and wanted to be on a newer version that 2007 lol. Have a good day over there in Lakeland - got some family in your town. Mike

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: 2003/2007/2010 compatibility puzzle!

    IFERROR function was first implemented in Excel 2007 and became one of the best functions to replace all error trapping functions. Unfortunately compatibility issues with legacy version remain a problem.
    I wish you all the best. The weather is very nice in Florida this time of the year

  5. #5
    Registered User
    Join Date
    12-06-2013
    Location
    Basingstoke, Hampshire
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: 2003/2007/2010 compatibility puzzle!

    Just for closure, I substituted =IF(ISNA(L6),0,L6) in place of =IFERROR... and the whole spreadsheet came good. The problem was not as bad as I first thought because so many cells depended on information rippling through from just this one function. It's still a mystery to me why this has worked fine with my 2007 fies being read by a 2003 installation but it should fall over when I went to 2010. Oh well! Thanks again AlKey.

  6. #6
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: 2003/2007/2010 compatibility puzzle!

    Hi Mike,
    I am glad that you were able to resolve this issue. Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ 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. [SOLVED] Backwards compatibility issue between VB Excel 2010 -> 2003
    By IamSierraCharlie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-16-2013, 08:54 PM
  2. Compatibility issues with 2010 and 2007
    By keithaggies2019 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2013, 01:37 PM
  3. VBA Compatibility between Excel 2007 and 2010
    By dwsteyl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2013, 02:17 PM
  4. [SOLVED] Excel VBA 2003 2010 Compatibility with ExportAsFixedFormat
    By Max_Taylor in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-14-2012, 07:06 PM
  5. [SOLVED] Excel 2003 / 2010 compatibility
    By asgersax in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-30-2012, 10:46 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