We help IT Professionals succeed at work.

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?

wildminduk
wildminduk asked
on
Medium Priority
1,186 Views
Last Modified: 2012-05-11
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?

Comment
Watch Question

CERTIFIED EXPERT
Awarded 2010
Top Expert 2013

Commented:
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.
CERTIFIED EXPERT
Awarded 2010
Top Expert 2013

Commented:
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.
byundtMechanical Engineer
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2013

Commented:
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.

Author

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?
CERTIFIED EXPERT
Awarded 2010
Top Expert 2013
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.