Name cannot be the same as built-in name

  • Thread starter Thread starter Heli
  • Start date Start date
H

Heli

I have an excel spreadsheet which I have used for many years and which has
been updated through various versions of XL. It consists of 28 sheets each
having several defined print areas. It opens fine with XL2003 on XP. When I
try to open it with XL2007 I get the following warning:
Name cannot be the same as built-in name:
Old Name: Print_Area
New Name:
If I enter a new name the same warning pops up again and again and again.
Help please!
 
Name cannot be the same as a built in name

This is the weirdest problem, but what we have found is if 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.
 
Back
Top