Name Conflict



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?


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 2
Name conflict 3
name conflict 2
"name conflict" 3
'copy or move' name conflict 3
Excel 2007 Name Conflict 6
Name Conflict Dialog Box??? 3