Error message when opening an Excel 97-2003 worksheet in Excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1722152%22%20slang%3D%22en-US%22%3EError%20message%20when%20opening%20an%20Excel%2097-2003%20worksheet%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1722152%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20spreadsheets%20in%20Excel%2097-2003%20Worksheet%20format.%26nbsp%3B%20When%20I%20try%20to%20open%20the%20file%20in%20Excel%20365%20I%20immediately%20get%20an%20error%20message%3A%3C%2FP%3E%3CP%3EName%20Conflict%3C%2FP%3E%3CP%3EName%20cannot%20be%20the%20same%20as%20a%20built-in%20name%3C%2FP%3E%3CP%3EOld%20name%20Print_Area%3C%2FP%3E%3CP%3ENew%20name%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20give%20it%20a%20new%20name%2C%20I%20do%20get%20into%20the%20file%20but%20I%20have%20no%20idea%20where%20this%20might%20be%20inside%20the%20file.%3C%2FP%3E%3CP%3EWhy%20am%20I%20getting%20this%20error%20message%3F%26nbsp%3B%20Thanks%20for%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1722152%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1722189%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20message%20when%20opening%20an%20Excel%2097-2003%20worksheet%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1722189%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F812413%22%20target%3D%22_blank%22%3E%40CharlieAJ9N%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENewer%20versions%20of%20Excel%20reserve%20the%20name%20Print_Area%20for%20when%20you%20specify%20the%20area%20of%20a%20worksheet%20to%20be%20printed%20(Page%20Layout%20tab%20of%20the%20ribbon%20%26gt%3B%20Print%20Area%20%26gt%3B%20Set%20Print%20Area).%3C%2FP%3E%0A%3CP%3EIn%20older%20versions%20this%20name%20was%20not%20reserved%2C%20so%20you%20could%20give%20any%20range%20this%20name.%3C%2FP%3E%0A%3CP%3ETo%20see%20where%20the%20(renamed)%20range%20is%2C%20click%20Name%20Manager%20on%20the%20Formulas%20tab%20of%20the%20ribbon.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have spreadsheets in Excel 97-2003 Worksheet format.  When I try to open the file in Excel 365 I immediately get an error message:

Name Conflict

Name cannot be the same as a built-in name

Old name Print_Area

New name 

If I give it a new name, I do get into the file but I have no idea where this might be inside the file.

Why am I getting this error message?  Thanks for the help.

2 Replies
Highlighted

@CharlieAJ9N 

Newer versions of Excel reserve the name Print_Area for when you specify the area of a worksheet to be printed (Page Layout tab of the ribbon > Print Area > Set Print Area).

In older versions this name was not reserved, so you could give any range this name.

To see where the (renamed) range is, click Name Manager on the Formulas tab of the ribbon.

Highlighted

@Hans Vogelaar 

 

Thanks Hans for the explanation.  This one caught be by surprise.  I wish the error message had a much better explanation.

CharlieAJ9N