address of active cell not shown in name box

two596879

New Member
Joined
Mar 13, 2007
Messages
3
Three options are shown by clicking on the drop-down arrow on the right side of the name box: the active cell's address, (e.g. "C6") "print area" or "_Worldox". Worldox is a software system my firm uses to open (save, save as, etc) Excel and Word files instead of the Microsoft's normal file-open feature. Anyway, in all of the spreadsheet's cells, except one, the cell address shows in the name box. When one cell is active (C6 if it matters), "_Worldox" appears in the name box. Click on the drop down arrow and the only other option is "print area".
Does anyone know why this is happening or how I can fix the spreadsheet so C6 appears in the name box when cell C6 is active?

Thanks.
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Nalani

Well-known Member
Joined
Apr 10, 2009
Messages
1,047
It sounds like C6 is included in a Named Range.

Have you check your Named Range Manager?
 

two596879

New Member
Joined
Mar 13, 2007
Messages
3
Thanks, you were correct. For some reason cell C6 was a named range. I deleted it and "C6" now appears in the name box.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,550
Messages
5,529,472
Members
409,884
Latest member
Msinmath
Top