name conflict

Discussion in 'Microsoft Excel Misc' started by giulio de feudis, Apr 6, 2004.

  1. "name cannot resemble a reference" window comes after
    trying to change settings from r1c1 refeence style to
    a1.b1 style.

    any help will be appreciated.

    thanks a lot
     
    giulio de feudis, Apr 6, 2004
    #1
    1. Advertisements

  2. giulio de feudis

    DDM Guest

    Giulio, this prompt appears because a name that resembles a cell reference
    ("A1" for example) has been assigned either to a single cell or to a range
    somewhere in the workbook. The prompt should indicate the name that Excel
    has detected. If it does not, cancel the prompt, then check the names box by
    selecting Insert > Name > Define. Change or delete any names that resemble
    cell references, and you should be able to change the reference style.

    DDM
    "DDM's Microsoft Office Tips and Tricks"
    www.ddmcomputing.com
     
    DDM, Apr 6, 2004
    #2
    1. Advertisements

  3. You can give a cell (say x99) a name of "A1" if you're in R1C1 reference style.

    But if you change to A1 style, then that name "A1" looks too much like an
    address.

    So excel yells.

    I just change the name to _A1 (prefixing it with an underscore) when prompted.
     
    Dave Peterson, Apr 7, 2004
    #3
    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.