Excel Worksheet Tabs Disappeared in vista 64

The strangest thing has happened in my excel 2007, running in vista 64. As of yesterday, it no longer displays the individual tabs for worksheets in a workbook of existing files. Any new blank file it will show the standard three tabs. Its not a problem with the file which when viewed in vista 32 or xp still shows the tabs. I've searched the ms knowledgebase and the web, but this appears to be a one of a kind. The "unhide" worksheet feature is greyed out in excel.

Any ideas, suggestions would be welocme

Thanks, Mozman

Okay, let's try this:

1) Open the existing workbook.
2) Click on the Office Orb
3) Click "Excel Options"
4) Click "Advanced" in the left pane
5) In the left pane, scroll down to "Display options for this workbook"
6) Check the box that says "Show sheet tabs"

Right now, I haven't found a way to check it for everything, if it's a problem for multiple workbooks.

Hopefully this solves your problem

Thanks for the suggestion. I had already looked at this option and it is checked. I even tried unchecking and then checking it again. The strange thing is that it only affects all existing worksheets but not any new blank ones. I even tried uninstalling excel and re-installing it, with no change in the behaviour. Yet all the time I can see the tabs in other version of windows using the identical file.

mozman

Update: I solved the problem through trial and error. I was able to see the tabs again when I used the "full screen" option in the "view" menu, but of course the menu bar and ribbon disappear when you use this option. Using the short-cut ctrl+F1, I restored the ribbon and the tabs stayed. I still have no idea what caused the problem in the first place. Oh well ....

Well, I'm glad you were able to solve it. I won't ask you to recreate it to answer a question I had about it. If you tried this and can let me know the behavior in this case, please do:

If you started a blank workbook and saved it, then closed Excel, when you opened it would the tabs disappear?

Like I said, if you don't know, that's fine. Please don't try to recreate the problem to find the answer.

Thanks FightingScallion. Funny you should ask, I was actually in the process of creating a new spreadsheet with tabs with the idea of saving it and then checking what would happen. As I was filling the cells I noticed that the ribbon was missing, so I looked for the shortcut for hiding and showing the ribbon. As soon as I discovered the ctrl+F1 shortcut, I decided to try it out on my problem file, which I had open in the full screen mode. When it solved my problem, I closed the other file without saving and re-opening it. so the short answer is, I didn't get to try it, but I thought the longer answer was more interesting :-)

Mozman