• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1125
  • Last Modified:

A formula or sheet you want to move or copy contains the name 'XXX' which conflicts with a valid ange reference or a name used internally by Excel 2010. Do you want to use this version of the name?

I have an application which uses an excel file to produce reports.  
In Office 2003 it was all working fine. In 2010 however, I get the above error, it Mentions R8C27 first of all and then some more.
I go to Formulas and then NAme Manager but can't find the names it refers to to change them.  Where else would they be?

0
wildminduk
Asked:
wildminduk
  • 3
1 Solution
 
TommySzalapskiCommented:
It's internal names that it's conflicting with which means names used internally by Excel, not by you so you won't find them.
0
 
TommySzalapskiCommented:
R8C27 means row 8 column 27 (or range("AC8")) which is what I'm assuming you are using it to mean. You'll have to come up with a new method for making your names (maybe row8col27 or even C27R8) since Excel 2010 uses this format as actual names apparently now.
0
 
byundtCommented:
R8C27 is an invalid name in both Excel 2003 and Excel 2010. Excel 2003 just says it is invalid. Excel 2010 gives you a somewhat more informative error message saying that it conflicts with a built-in name or another object in Excel. In this case, the object is the cell referenced by the R1C1 address style where the number following R represents a row and the number following C represents a column.
0
 
wildmindukAuthor Commented:
My issue is that I want to find where it's using the reference it doesn't like and change it. It tells me there are conflicts, but doesn't tell me what exactly is conflicting with the internal names - how do I find out what's causing the issue?
0
 
TommySzalapskiCommented:
You could parse through the names in VBA code and search them for the offending string.
Something like this maybe
Sub CleanNames()
Dim n As Name

On Error Resume Next
For Each n In ThisWorkbook.Names
  If n.Name Like "*R*C*" Then
    MsgBox "Found it"
    'n.Delete
  End If
Next
End Sub 

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now