Dissapearing Tabs in Excel 2007

Jim_T

New Member
Joined
Sep 16, 2010
Messages
6
The "Tabs" at the bottom of the worksheet just disappeared, and so did the horizontal scroll bar.
Adv. Options: scroll bars are turned on. Working in the Normal mode.
Closed Excel, re-opened the 2 files and problem still exists.

However, when opening a new worksheet, the tabs are there.


How do I get them back?
Probably should not have taken that coffee & donut break. :LOL:
 

doofusboy

Well-known Member
Joined
Oct 14, 2003
Messages
1,325
Have you tried from the ribbon/menu:

Home - Format - Hide & Unhide - Unhide Sheet
 

Jim_T

New Member
Joined
Sep 16, 2010
Messages
6
That option seems to be for hiding/unhiding the whole sheet.
The sheet is displayed - just not the sheet tabs at the bottom, of which I currently (had) 5 tabs open.
 

Jim_T

New Member
Joined
Sep 16, 2010
Messages
6
What I recommended is for unhiding each "tab" as you call them.
doofusboy - thanks for your reply. However, in Excel2007, I cannot find any option for unhiding the "Sheet Tabs" on the menu you suggested above - only for the whole sheet.
What I did was copy the file to my laptop and opened with Ex.2007 - and bingo, the sheet tabs were back. I made changes to the file, saved (to a new name), and then copied back to the desktop machine where the new updated file now opens normally.

However, the original file still opens without the sheet-tabs; therefore it is an error function within that saved file not with Ex.2007 itself.

Just another Microsoft fluke???
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,724
Go to the Office button, Excel Options, Advanced, scroll down until you see Show sheet tabs, make sure it's checked.

I believe it's a workbook setting, so should save with the workbook.
 

meguilbert

New Member
Joined
Oct 7, 2008
Messages
35
doofusboy - thanks for your reply. However, in Excel2007, I cannot find any option for unhiding the "Sheet Tabs" on the menu you suggested above - only for the whole sheet.
What I did was copy the file to my laptop and opened with Ex.2007 - and bingo, the sheet tabs were back. I made changes to the file, saved (to a new name), and then copied back to the desktop machine where the new updated file now opens normally.

However, the original file still opens without the sheet-tabs; therefore it is an error function within that saved file not with Ex.2007 itself.

Just another Microsoft fluke???
Did you leave your computer open when you took your coffee break? At my job thats a big no-no. Because we have some prankster that will mess with settings, presentations, etc. We have had some great ones. Like photos of your past showing up in your presentations.:ROFLMAO:
 

Jim_T

New Member
Joined
Sep 16, 2010
Messages
6
Zack, yes it is checked. That is why it works with other workbooks; and it also worked for the first two days while I prepared this fantastic workbook with 10 tabs.

As I said before, I probably should not have taken a coffee & donut break ;>)
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,724
LOL! Yeah. Are you sure no macros are running on your workbook? It could be set with code. Can you upload the workbook, or post a screenshot? Can you reset then set that option with the desired change?
 

Jim_T

New Member
Joined
Sep 16, 2010
Messages
6
Meguilbert, Excellent, great piece of detective work!

Was working on this project at my home office, and did leave the computer on... so definitely will check for squirrels or gremlins.
 

Forum statistics

Threads
1,082,574
Messages
5,366,398
Members
400,887
Latest member
tporeda

Some videos you may like

This Week's Hot Topics

Top