T
Tia
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!
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!