Results 1 to 4 of 4

Compatibility issue - 2003 -> 2013

Threaded View

1eyedjack Compatibility issue - 2003 ->... 03-12-2014, 02:43 PM
1eyedjack Re: Compatibility issue -... 03-12-2014, 02:55 PM
icestationzbra Re: Compatibility issue -... 03-12-2014, 03:19 PM
1eyedjack Re: Compatibility issue -... 03-13-2014, 04:59 AM
  1. #1
    Forum Contributor
    Join Date
    11-14-2007
    Posts
    142

    Compatibility issue - 2003 -> 2013

    Hello. I attach a workbook. It has macros in it but the macros are not the issue.
    The workbook was created in Excel 2003 and worked fine under that version.
    It also works fine (so far, testing incomplete) if opened in compatibility mode in Excel 2013, ie preserving .xls format when saving.
    But if I try to save it as a .xlsm file in Excel 2013 it presents a peculiarity:
    Then, it dislikes two of the defined names, "Ref1" and "Ref2" (localised to sheet "stmt (0)", which evaluate to #REF! error.
    Note that these names evaluate to #REF! error while in .xls format without causing any problems in Excel 2003.
    Anyway, Excel 2013 insists on renaming these defined names as "_Ref1" and "_Ref2" respectively.
    But what also seems particularly odd is that these are not the only two names which evaluate to #REF!. For example the name "Date2" which also is local to "stmt (0)" is almost identically defined and also evaluates to #REF!, but conversion from .xls to .xlsm leaves that defined name intact.

    None of these names evaluate to #REF! once the macro to Add Rows has been run, and I would much prefer to leave "Ref1" and "Ref2" names as originally defined.

    Any ideas what is going on?

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compatibility issue with Excel 2013
    By kinokino in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-02-2013, 04:17 AM
  2. Macro Compatibility Issue : Office 2003 and 2007
    By angeld27 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2011, 01:03 PM
  3. is there compatibility issue between 2003 & 2007
    By tushar@excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2008, 09:07 AM
  4. Protection compatibility issue 2002/2003
    By Bjornar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-05-2008, 03:46 PM
  5. Compatibility issue? Excel97/2003
    By HBj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-03-2005, 06:06 PM

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