Hi,
I had the same problem with excel and after reading 2 days on intrenet I could not find an otpimum solution.
What I did was just to delete the underscore between Print and Area and this worked.
So, you have to put the new name PrintArea instead of Print_Area and press OK. When the file opens go to save as and save it with a different name.
Good luck.
Rick B wrote:
"Name Conflict" opening an Excel 2003 workbook
28-Sep-07
I'm getting a "Name Conflict" "Name cannot be the same as a built-in name."
Old name: Print_Area
New name:
All of the solutions I've read is to load this into Excel 2003, fix the
problem, then re-save it. But I do not want to load Excel 2003 on a box
just to do this for a few spreadsheets. I downloaded a program called
NameManager.zip but this only works, from what I can tell, once you have
opened the file. The whole problem is I can't get the spreadsheet opened
with this name conflict. Is there a solution?
Thanks,
Rick
Previous Posts In This Thread:
"Name Conflict" opening an Excel 2003 workbook
I'm getting a "Name Conflict" "Name cannot be the same as a built-in name."
Old name: Print_Area
New name:
All of the solutions I've read is to load this into Excel 2003, fix the
problem, then re-save it. But I do not want to load Excel 2003 on a box
just to do this for a few spreadsheets. I downloaded a program called
NameManager.zip but this only works, from what I can tell, once you have
opened the file. The whole problem is I can't get the spreadsheet opened
with this name conflict. Is there a solution?
Thanks,
Rick
Have you tried re-naming it?
Have you tried re-naming it?
Regards,
Alan.
I did go through renaming them but it ends up being about 20 of them.
I did go through renaming them but it ends up being about 20 of them. Then
it appears to break the spreadsheet (very complex spreadsheet). I'm taking
the spreadsheets to another system running Office 2003 offsite to see what
they are suppose to be and then try renaming them and see if the sheet still
works.
It should do, I've never known renaming a file to cause any
It should do, I have never known renaming a file to cause any problem,
Regards,
Alan.
The names Print_Area, Print_Titles, Consolidate_Area and Sheet_Title are
The names Print_Area, Print_Titles, Consolidate_Area and Sheet_Title are
reserved for use by Excel.
Re: "Name Conflict" opening an Excel 2003 workbook
I've seen that in spreadsheets created in an Asian (double-byte)
character set and opened in a Western (single-byte) Office
installation. Two (or more) names that are different in the original
language end up with the same name in the restricted character set.
You could try opening the s/s in an installation with the originator's
character set installed. After all, they had to have been *saved* with
no name conflict, so they should be openable that way too.
Patrick
It's not a unicode problem. The spread sheet uses a reserved name, Print_Area.
it is not a unicode problem. The spread sheet uses a reserved name,
Print_Area. The names Print_Area, Print_Titles, Consolidate_Area and
Sheet_Title are
reserved for use by Excel.
Re: "Name Conflict" opening an Excel 2003 workbook
That's what I'm saying.
Each sheet has its own Sheet1!Print_Area etc.
When originally saved, they are (have to be) all different.
When opened in a Western set, two sheet names become coincidentally
the same.
The names would look to us something like
[][][][][]!Print_area
[][][][][]!Print_area
Which are now, in our installation of Excel, the "name cannot be the
same as a built-in name" that our Excel now complains about.
Submitted via EggHeadCafe - Software Developer Portal of Choice
Cool Features of Visual Basic 6.0 Objects!
http://www.eggheadcafe.com/tutorial...4-8c081a7d2976/cool-features-of-visual-b.aspx