Name Conflict

Discussion in 'Microsoft Excel Misc' started by Tia, Aug 5, 2003.

  1. Tia

    Tia Guest

    I need help changing the cell reference style from R1C1
    back to the A1 reference style. When I try changing it
    using the normal Tools-Options-General method, I get a
    Name Conflict message which says, "Name cannot resemble a
    reference." The message box displays an "Old Name" and
    then asks for a "New Name".
    I have no idea why Excel prompts me for this. There are
    some names in the workbook which were set up by the
    initial creator of the file, but most of the names don't
    reference valid sheets anymore (the sheets were probably
    deleted a long time ago). Does anybody have any idea how
    I can change back to the A1 notation?

    Thanks!
     
    Tia, Aug 5, 2003
    #1
    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.