asked on 5/17/2011

Excel 2007

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.

Microsoft Excel Microsoft Office

Last Comment

timgreen7077

5/17/2011

ASKER CERTIFIED SOLUTION

Anil

5/17/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

timgreen7077

5/17/2011

ASKER

the 3 option worked. any idea what cause this? we can't expect the user to do this everytime.

AccountingDev

5/17/2011

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

Anil

5/17/2011

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>

timgreen7077

5/17/2011

ASKER

thanks