One sheet has no name on the tab

[JenniferMurphy]

I have a curious situation. A workbook I have been working on for several weeks has about 20 sheets. I just noticed that one of the most recent sheets was missing. I checked to see if it was hidden, but found nothing. Then I noticed a tiny all-white tab (no label). If I click on it, my missing sheet appears.

Here's what the tab row looks like. The circled tab should read "Active Log". If I click on it, I get the active log.

What did I do to deserve this little gift?

 

[JoeMo]

That never even occurred to me. I did just that and it is now visible:

View attachment 31015

That solved my immediate problem, but I'm going wait on marking this solved hoping that someone can explain why it happened and, more importantly, what I can do to prevent it from happening again.

You may be right. It may just be one of the many joys of Office 365. I have had more trouble with several Office 365 apps in year or so that I have had it, than in 10-15 years with previous versions. Do they (M$ST) always have to take 2 steps back after taking 3 steps forward? Sheesh.

Possibly you inadvertently replaced the name with one or more spaces. Excel accepts that as a valid sheet name. Excel does not accept a blank tab.

 

[JenniferMurphy]

Would be curious to see what the reference to a cell on that "no-name" tab looks like.

That's a great suggestion. Unfortunately, it is no longer nameless. If it happens again, I'll try to get my Alzheimer's-addled brain to remember to try that. Thanks

 

[JenniferMurphy]

developers who can't cut it in the OS group are transferred to the Office group.

Nuff said !!

Actually, as I think about it, I believe he said something like: Developers who can't cut it in the OS group are reassigned as tech writers. If they can't cut it there, they are then sent to the Office group as a developer. If they can't cut it there, they are reassigned as Office tech writers. If they can't cut it there, they are sent to marketing. And if they can't cut it there, they are sent to sales.