![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
Welcome to Vista Forums we are your forum to discuss Windows Vista x64 and x86 systems. Whether you need help or just want to post an idea you have on Vista, this is the forum for you.
br>
|
|
|||||||
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 | ||
|
Newbie
![]() Join Date: Jan 2008
Vista Ultimate 32bit
Posts: 4
|
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 |
||
|
|
|
|
|
|
|
|
#2 | ||
|
Enthusiast
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Join Date: Aug 2007
Windows Vista Home Premium x64 SP1
Posts: 423
|
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 ![]() |
||
|
AMD Athlon 64 x2 6000+, 6GB DDR2 PC6400 (800MHz) RAM, 2x Sapphire ATI Radeon HD 3870 XT 512MB GDDR4 TOXIC Edition (Crossfire Mode), ASUS M2R32-MVP Motherboard, Creative SoundBlaster X-Fi XtremeGamer, Western Digital 250GB HD
|
|||
|
|
|
|
|
#3 | ||
|
Newbie
![]() Join Date: Jan 2008
Vista Ultimate 32bit
Posts: 4
|
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 .... Last edited by mozman_1970; 03-03-2008 at 09:32 AM. Reason: update information |
||
|
|
|
|
|
#4 | ||
|
Enthusiast
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Join Date: Aug 2007
Windows Vista Home Premium x64 SP1
Posts: 423
|
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. |
||
|
AMD Athlon 64 x2 6000+, 6GB DDR2 PC6400 (800MHz) RAM, 2x Sapphire ATI Radeon HD 3870 XT 512MB GDDR4 TOXIC Edition (Crossfire Mode), ASUS M2R32-MVP Motherboard, Creative SoundBlaster X-Fi XtremeGamer, Western Digital 250GB HD
|
|||
|
|
|
|
|
#5 | ||
|
Newbie
![]() Join Date: Jan 2008
Vista Ultimate 32bit
Posts: 4
|
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 |
||
|
|
|
|
|
|
|