Name Conflict

Discussion in 'Microsoft Excel Misc' started by Roger, Mar 14, 2008.

  1. Roger

    Roger Guest

    I recently install Office 2007. I have Excel files created in Office 2003
    that I can not open. I get a message box: "Name Conflict" "name cannot be
    the same as a built-in name". Then below that message is: "old name:
    Print_Titles" ,then below that a box to enter "New name:" I'be tried
    everything I know.
     
    Roger, Mar 14, 2008
    #1
    1. Advertisements

  2. Roger

    Kassie Guest

    Have you tried to change the name in Explorer, and to then open it?
     
    Kassie, Mar 14, 2008
    #2
    1. Advertisements

  3. Maybe you can open the workbook in xl2003. Remove the name and save the file.

    Then open the newly saved file in xl2007.

    Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager
    addin should make it a bit easier.

    You can find it at:
    NameManager.Zip from http://www.oaltd.co.uk/mvp
     
    Dave Peterson, Mar 14, 2008
    #3
  4. Roger

    Roger Guest

    Yes, I've tried all kind of names, numbers, nothing works. I've never heard
    of this "Name Conflict" message and I don't understand what a "built-in name"
    is.
    Thanks,
     
    Roger, Mar 14, 2008
    #4
  5. Roger

    Roger Guest

    I used Explorer to drag the file to a diskette, went to another pc that has
    Excel 97, opened the file with no problem. Saved the file using a different
    name and as a Excel 97 workbook. Came back to 2007 and same problem. I can
    not open the file. I've never heard of this "Name Conflict" or "built-in
    name". I have no idea what that means and can not find any help with
    Microsoft Help topics.
    Thanks,
     
    Roger, Mar 14, 2008
    #5
  6. Workbooks can have names that refer to ranges, constants, formulas.

    Excel uses its own names and you can create your own, too.

    Get that addin and open it and your workbook in xl2002 and you'll see that you
    have names in that workbook.

    You can create names via:
    Insert|Name|define
    (xl2003 menu system)

    And if you type Name into excel's help (in the search box), you should find lots
    of hits.
     
    Dave Peterson, Mar 14, 2008
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.