My workbook tabs have all disappeared !!!

[GregDiel]

Hi all,

Hoping someone can help me out here. All of the tabs for any worksheet I open have now disappeared. They aren't completely gone because I can navigate though a right click event but I cannot see them.

I have checked under Tools --> Options and verified that the box is checked to show tabs so it isn't that simple.

If you see below you may understand what I mean. The tab section is showing but it's like there is something blocking it. This happens with existing or new documents and with Template I download from the web. If I send files to anyone they work fine and all the tabs are visable to them. If they send back it's the same as before, so it isn't a file issue.

Has anyone ever seen this before and know how to fix it without running a repair on Excel or reinstalling it?

 

[texasalynn]

go to Tools - Options - View
click on "Sheet Tabs"

 

[ghard1]

Display the sheet who's tab you cannot see. Click on Format, then Sheet, and select "unhide"

Or,

Try sliding the tab split bar (bar beside the side to side scroll bar) and see if they reappear

Hope this helps

 

[GregDiel]

I already tried all of those already and still no go.

The sheets aren't hidden persay, it's more like there is a huge blank tab covering all of them.

 

[Macropheliac]

Click the Maximize icon at the top of the screen. If that's not it, your Taskbar is probably too wide. Place your cursor over it until you see the arrow and drag it down.

Or maybe not

Mac

 

[GregDiel]

no go on that one either.

 

[cmhoz]

someone describing a similar problem on another board managed to get his sheet tabs back by doing:

Window -> Arrange -> Tiled, and click 'windows of active workbook'

I know, in theory, it's unrelated.. but perhaps it acting as someing of a reset?

 

[GregDiel]

****.

No good with that one either. This is really getting frustrating! :-O

 

[Domski]

Weird.

Looks like the sheet tabs are there but the horizontal scroll bar is covering them up in some way.

Can you drag it out of the way?

Can you select the different sheets by using Ctrl + Page Up/Down.

If so I'd maybe try selecting the all by holding Shift at the same time and then using the Move or Copy sheet and bung them into a new workbook.

 

[irresistible007]

i can see that there is an add-in running.... disabling all custom addins and restarting the excel maysolve it...<crossed finger>