Excel 2007

timgreen7077
timgreen7077 used Ask the Experts™
on
I have a user that imported data to an excel doc and when he tries to open it this is the message he gets: "name cannot be same as builtin name" Embedded is what the user is getting. I tried renaming the file, i tried putting a new name in the text field but nothing works. The file is saved as a .xls and not the newer .xlsx The user is using office 2007. You can't open the file, when you try to the name confilict windows opens. Do any of you have any ideas on this. error
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Data Manager
Commented:
From : http://www.pcreview.co.uk/forums/name-conflict-name-cannot-same-built-name-t3824497.html


Jan Karel Pieterse, Excel MVP has in the past offered this explanation.
Excel checks the integrity of a file when it opens it. Your file contains a
problematic range name (Insert, Name, define), which coincides with built-in
range names Excel normally manages itself.
In this case, you probably have a (I expect workbook-scoped) name called
Print_area. This is one of those reserved range names managed by Excel.
Print_area range names normally are worksheet-scoped, which is why this name
causes an error message.

These may be possible solutions:
1. Open in 2003 and resave with a new name
2. Use Rename in the folder view (windows explorer)
3. When the first time this box comes up you enter a new name with 1
character, it will open. Then you should immediately resave the file. If the
second time opening it, put a new name with 2 characters, and so on. If you
can't get the file open just keep trying adding 1 character each try until
the file actually open.
Hope this helps
timgreen7077Exchange Engineer
Distinguished Expert 2018

Author

Commented:
the 3 option worked. any idea what cause this? we can't expect the user to do this everytime.
It appears you have an error on a Named Selection ie the Name of Range(A4:C19);  You can do something to the effect of
 
    Workbooks.Open Filename:= _
        FILETOCOPY
    Sheets("SHEETTOCOPY").Copy After:=Workbooks( _
        "DESTINATIONFILE.EXT").Sheets("Sheet1")
    Windows("FILETOCOPY.EXT").Activate
    ActiveWindow.Close   

Open in new window

  This would copy in the entire sheet, and you can do an array of sheets as well, or you can just c/p into an existing sheet:
    Workbooks.Open Filename:= _
        FILETOCOPY
    Sheets("SHEETTOCOPY").Select
    Cells.Copy
    Worksbooks("DESTINATIONFILE.EXT").Activate
         Sheets("DESTIONATIONSHEET").Select
    [a1].PasteSpecial xlPasteValues
    Application.CutCopyMode = False

Open in new window

AnilData Manager

Commented:
When this happened to me I went to the named ranges dialog and looked for that particular name reange and deleted  it.
I then changed its scope and redefined it in Excel 2007.

A>
timgreen7077Exchange Engineer
Distinguished Expert 2018

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial