×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel 2016 name box missing

Excel 2016 name box missing

Excel 2016 name box missing

(OP)
I've searched a good bit and I can not figure this out. I have a number of files where the name box is missing. This is the box that shows the name of the cell you are in or when you start to type a formula it gives you a pull down menu of recently used functions. It should look like this (showing A20 in the pic):



But certain files don't show the name box which makes it really hard to enter formulas. They look like this:



These files are in different windows of the same session. It seems to go with the files. Turning the formula bar off and on does not fix the problem.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

Never come across that particular issue, but sometimes other addins (especially com addins) can mess with Excel inadvertently, maybe if you have any addins enabled try temporarily disabling these and see if it has any effect.

RE: Excel 2016 name box missing

I can't find anything on this. Presumably it is a file related setting. Does it occur when the files are opened by themselves?

Probably worth raising in an Excel specific forum if you get nothing here.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Excel 2016 name box missing

(OP)
Been awhile since it's happened but I just had one today. I saved it, renamed it, opened it again and the name box is back. Same Excel session, still have 3 other files open. I was about to attach it but no point. I've got another one open at the moment that is missing the name box but the other files are fine.

OK, I deleted all the data out of a file with the name box missing and this time the behavior is sticking when I reopen it. File attached.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

(OP)
Well, that didn't really work, when I down loaded the file I just uploaded it the name box was back.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

Ditto.


XL2016 appears to have a number of oddities:
> repeated instances where cursor and cell selections refuse to show up on screen, even though the underlying operation works
> supposedly identical version of 2016 Plus does not have pinned folders, only pinned files.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: Excel 2016 name box missing

I did some Google searching on the issue. Didn't really turn up any reasons as to why it is happening, but it appears to be across many version of excel back to 2010. Someone said to close excel, then open task manager and if excel is still running in the background, kill the task. Then re-open the file and it should be fine.
I have never come across this issue myself.

RE: Excel 2016 name box missing

Does Ctrl-Shift-U happen to bring it back?
Or Ctrl-F1?
Or in the View ribbon un- and re- checking Show Formula bar?

RE: Excel 2016 name box missing

(OP)
Nope, none of those make a difference.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

(OP)
Closing and restarting seems to fix it but it comes back after working for awhile.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

Can you run excel with all add-ins disabled to see if they are causing this? (if you have any running). You can check under file/options/add-ins to see which ones are running. Then at the bottom you can manage excel add-ins and com add-ins

Another option would be to try "repairing" the Microsoft office installation by going to Add or Remove programs in windows, finding Microsoft Office, clicking Modify, then click repair.

RE: Excel 2016 name box missing

(OP)
No add-ins. Did the "repair" on MS Office and no change. I opened 4 spreadsheets after the reboot and 3 of them were missing the name box. I went to file/info/inspect but there was nothing unusual about the files with the missing name box.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

Another possibility is that something got corrupted in the binary metadata for the files, so you might possibly try downsaving to an older file format and then upsaving to the current format.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

RE: Excel 2016 name box missing

I have seen bugs in video card drivers do strange things to programs. Can you update your video card drivers?
Also, do you have one of those "High DPI monitors" or just a standard 1920x1080 resolution monitor.
I've seen funny things happen when attempting to scale to the 4k monitors.

RE: Excel 2016 name box missing

(OP)
I run dual 24" monitors at 1920x1200 native resolution. I updated the driver back in September because that was when I was forced to update to Windoze 10. The problem predates those changes but it does seem to happen more frequently now.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

Win 10 also caused graphics issues for me in Excel 2016 (no other apps) - name box was ok but formula bar would vanish, charts & their formatting dialogues went haywire, and sometimes it would get stuck in a loop of refreshing/redrawing. Update of graphics drivers at the time (and everything else we could think of) did not help. However a more recent update of the drivers significantly reduced the incidence (Still happens but much less).
John.

RE: Excel 2016 name box missing

(OP)
I was looking at all the installed programs on this machine and noticed that it had MS Office 2010 and 2016 installed. I use a couple utilities from Office 2010 that were stripped out of later versions. I reconfigured Office 2010 and uninstalled Excel and every other component that exists in 2016. So far so good, no missing name boxes. It's only been a couple of days so maybe I'm premature to declare victory. I'll come back if the problem reoccurs.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

(OP)
Nope. Just opened one today with the name box missing. I've got another spread sheet open and it has the name box.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

I would check to see what version of Excel the files are saved as. You may need to save the ones that aren't showing the name box as the most recent version of Excel.

Also, from the View tab, verify that Formula Bar box is checked in the Show area.

RE: Excel 2016 name box missing

(OP)
It's happening in the same session, some do, some don't. Formula bar box is checked. I can close an offending file without saving, open it again and the name box is back (some times, not every time). Frustrating!

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

(OP)
I book marked that link for future use although I don't think it's necessarily apropos. None of these spreadsheets give any indication of being corrupted.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

dgallup,
It was not to be taken literally as a repair action on corrupted file. I realize files are probably not corrupted per se.
I thought to misuse repair facility so it may work at deep level of the file structure and maybe, remove/replace the problematic sequence, if any. Just an attempt.

RE: Excel 2016 name box missing

Is there any possibility that your Personal.xlsb file is doing things to some worksheets but not others, or is itself corrupt?

RE: Excel 2016 name box missing

(OP)
I searched and did not find a personal.xlsb file, where would such a thing normally be located?

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

My personal.xlsb file is at the following location.
C:\Users\MYUSERNAME\AppData\Roaming\Microsoft\Excel\XLSTART
I use it to store a bunch of VBA scripts / macros that I use across various excel files. I think the issue would be if there is a script in there that is automatically running on every excel file you open.

If the file is not there, you can find it using a short command:
On Windows:
Open Excel.
Press alt+F11 to open the VBE.
If the immediate window is not visible, press ctrl+g to make it so.
In the immediate window, type ?Application.StartupPath
Press enter/return

From https://wheatblog.com/2011/08/where-is-the-excel-p...

RE: Excel 2016 name box missing

In your first post, there is a button in your quick launch bar with blue, white, blue, and red boxes. What is that? Is it some sort of add-in? Just wondering if it is causing issues.

edit:
Another way to check for plugins is to run Microsoft/Sysinternals Autoruns program.
Click on the Office tab, scroll down to Excel, and it will show you the plugins that will run when excel starts. There will probably be multiple sections for excel.
This program is great to stop programs from auto-starting when windows starts. Just untick the box on the left. You can run the autoruns program again later and re-tick to box if you change your mind.

https://docs.microsoft.com/en-us/sysinternals/down...

RE: Excel 2016 name box missing

(OP)
I have C:\Users\MYUSERNAME\AppData\Roaming\Microsoft\Excel\ but it does not have an XLSTART folder in it.

The quick launch bar button with blue, white, blue, and red boxes is just the page layout/colors command. I find many spreadsheets have hideous colors and I like to reset them to Office 2007-2010. Some things should never change.

Autoruns does not seem to be part of the default Windows 10 install. I found this link to install it.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

CODE --> dgallup

Autoruns does not seem to be part of the default Windows 10 install. I found this link to install it. 
Yes, that is the correct link. Same one I posted above. Sysinternals has a lot of very useful applications.

RE: Excel 2016 name box missing

XLSTART may be a hidden folder inside C:\Program Files\Microsoft Office\root\Office16.

You should be able to get there by typing directly into a folder view of your drive, Windows should go there even if it is hidden but you have to know it is there and type it correctly.

RE: Excel 2016 name box missing

(OP)
I'll give that a try next time it happens.

There are so many background processes running it's amazing any useful work is possible at all.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

(OP)
Just had it happen again. Two files open simultaneously, both came from the same template, both relatively new files created within the last week or two. One file has a name box, the other one does not. Closed them both and task manager shows no excel process running. Opened them both back up and both have a name box. Closing and reopening seems to work about 90% of the time so at least that's a pretty decent work around.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

(OP)
I completely uninstalled MS Office and reinstalled it and the problem has not come back. Less drastic than I expected, all my settings remained.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Excel 2016 name box missing

(OP)
Well, that worked for awhile but the missing name box came back yesterday. Closing and re-opening the file fixed the problem. Where would we be if we didn't have Bill Gates to curse?

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close