"Name Conflict" when Excel 2007 open an old worksheet

[Chik]

Hi all,

An "Name Conflict" error message pop-up "Name cannot be the same as a
built-in name". That worksheet was created by Excel 2000 and also could open
on
Excel 2003 without any error message. Change the worksheet file name could
not solve the problem after tested. Why?

Thank you,

Chik

 

[Harlan Grove]

An "Name Conflict" error message pop-up "Name cannot be the same as
a built-in name". That worksheet was created by Excel 2000 and also
could open on Excel 2003 without any error message. Change the
worksheet file name could not solve the problem after tested. Why?

Just because it can open in XL2003 doesn't mean it should open in
XL2007. And as you've seen for yourself, it's not the filename.

A guess: you have defined names that happen to match cell addresses in
the new grid, e.g., ABC123456 was a valid name in XL2003 and prior,
but isn't in XL2007.

If you can't open the file at all under XL2007, do you still have
XL2003 or XL2000? If so, you'll need to open the file in the older
version, change the name(s), resave, then open in XL2007.

 

[Harlan Grove]

A guess: you have defined names that happen to match cell addresses
in the new grid . . .

....

Did a web search, and this may not be the problem. There could be new
built-in names in XL2007 like the older Print_Area and Print_Titles
that Excel uses for new functionality. If so, you'll need to change
those defined names.

 

[Dave Peterson]

Just to add to Harlan's advice...

If you're working with names, get Jan Karel Pieterse's (with Charles Williams
and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It might make finding that offending name easier.

 

[Chik]

Hi Harlan,

The popup need me to change built-in name of "Print_Titles" somethink like
that. Where I can change it?

Thanks,

 

[Chik]

Thanks...

Just to add to Harlan's advice...

If you're working with names, get Jan Karel Pieterse's (with Charles
Williams
and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It might make finding that offending name easier.

 

[Nick Hodge]

Chik

You may also need to look at any range names beginning with xl. This is now
a reserved start to range names in XL2007, although Excel 2007 should handle
this on opening new workbooks by putting _ in front

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk