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?

 

[Michael M]

Have you tried renaming it ??
Probably another reason to avoid 365 !!

 

[JenniferMurphy]

Have you tried renaming it ??
Probably another reason to avoid 365 !!

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

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.

 

[Michael M]

Well if 365 was perfect....you wouldn't buy 365 Plus or 365 Version2...when they finally get released...
It's always about making money !!!

 

[JenniferMurphy]

Well if 365 was perfect....you wouldn't buy 365 Plus or 365 Version2...when they finally get released...
It's always about making money !!!

I'm not expecting perfect. I just wish each release had fewer stupid bugs than the previous one.

One of my favorite books of all time was Woody Leonhard's book, Hacker's Guide to Word for Windows. I thought that book would embarrass M$FT enough that they would get their act together. Sadly, it did not.

I know someone fairly high in the OS development group. He told me many years ago that developers who can't cut it in the OS group are transferred to the Office group.

 

[Michael M]

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

Nuff said !!
I'll be interested to see if your Tab issue happens again..

 

[Peter_SSs]

Probably another reason to avoid 365 !!

Any reason to think it might even possibly be related to Excel 365 rather than a simple (presumably accidental) renaming (per your first comment) or a corrupted file?

 

[Michael M]

Yep...possibly...but 365 has created some interesting issues thus far ?

 

[JenniferMurphy]

Any reason to think it might even possibly be related to Excel 365 rather than a simple (presumably accidental) renaming (per your first comment) or a corrupted file?

I don't know what "renaming" you are referring to in my "first comment".

If it was a corrupted file, how come simply renaming that tab (that was in my second comment) fixed the problem and the workbook is working just fine since. And if it was corrupted, Excel should detect that and tell me. Actually, it should prevent corruption in the first place. M$FT owns the Office software and the OS.

 

[Tetra201]

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