name conflict

  • Thread starter giulio de feudis
  • Start date

G

giulio de feudis

"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
 
D

DDM

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
 
Ad

Advertisements

D

Dave Peterson

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.
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Name Conflict 5
Name Conflict 0
Name Conflict 2
Name conflict 3
"name conflict" 3
'copy or move' name conflict 3
Excel 2007 Name Conflict 6
Name Conflict Dialog Box??? 3

Top