Excel 2007 Name Conflict

[ShbgnXpat]

When importing spreadsheets from an external data source, I get an "Name
Conflict" error message, stating that the "Name cannot be the same as a
built-in name" and giving the old name of "Print_Titles" & a space to enter a
new name, with space to enter the new name. Any random keystroke + ENTER
clears the error, but I need to know how to prevent this annoying extra step.
Any suggestions?

 

[Jan Karel Pieterse]

Hi ShbgnXpat,

When importing spreadsheets from an external data source, I get an "Name
Conflict" error message, stating that the "Name cannot be the same as a
built-in name" and giving the old name of "Print_Titles" & a space to enter a
new name, with space to enter the new name. Any random keystroke + ENTER
clears the error, but I need to know how to prevent this annoying extra step.
Any suggestions?

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_Titles. This is one of those reserved range names managed by Excel.
Print_Titles range names normally are worksheet-scoped, which is why this name
causes an error message.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[ShbgnXpat]

So basically, since this file is coming from an external source over which I
have no control prior to opening it, I can expect to continue seeing & then
bogusly responding to this error ad infinitum?

 

[Jan Karel Pieterse]

Hi ShbgnXpat,

So basically, since this file is coming from an external source over which I
have no control prior to opening it, I can expect to continue seeing & then
bogusly responding to this error ad infinitum?

Such is life <g>. You might try to report the problem to them?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com