Dissapearing Tabs in Excel 2007

[Jim_T]

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.

 

[doofusboy]

Have you tried from the ribbon/menu:

Home - Format - Hide & Unhide - Unhide Sheet

 

[Jim_T]

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.

 

[doofusboy]

What I recommended is for unhiding each "tab" as you call them.

 

[Jim_T]

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]

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]

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.

 

[Jim_T]

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]

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]

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.