Solved

Excel 2007 will not display sheets

Posted on 2013-12-06
7
227 Views
Last Modified: 2013-12-07
I'm not an Excel wiz, but I have a file I created at work and it has 4 sheets to it that are accessible by the sheet tabs at the bottom.  I emailed this file and several other multi-sheet files to my home and opened them up in Excel.  The same exact Excel that is on my work computer.  Same operating system, Win 7.  BUT the sheet tabs at the bottom are gone on every file.  Where did it go and how do I get it back?  I can take this file back to work and the sheet tabs are there, back at home they are gone. Help!
0
Comment
Question by:ArtG2521
7 Comments
 
LVL 13

Expert Comment

by:akb
ID: 39702570
Refer to:
http://office.microsoft.com/en-au/excel-help/hide-or-show-worksheets-or-workbooks-HP001217033.aspx


On the Home tab, in the Cells group, click Format.
Excel Ribbon, Home tab, Cells group
Under Visibility, click Hide & Unhide, and then click Unhide Sheet.
In the Unhide sheet box, double-click the name of the hidden sheet that you want to display.
NOTE   You can unhide only one worksheet at a time.
0
 
LVL 90

Expert Comment

by:John Hurst
ID: 39702586
Also on the home machine try an Office Repair just to be sure. Go into Trust Center in Excel and check (select) the option that says "Download a file from Microsoft periodically".  Close out of Office applications, go to Control Panel, click on Office, Change and Repair. Allow the Repair to run and check.

Make sure all 3 Office Service packs have been applied.

... Thinkpads_User
0
 
LVL 80

Accepted Solution

by:
byundt earned 500 total points
ID: 39702595
My guess is that your monitor is smaller at home than at the office, and that you have not maximized the worksheet within the application window.

Try clicking the Maximize icon (circled in picture below) at upper right of the worksheet (not application) pane. You may need to drag the worksheet (where shown) to the left in order to see it.
Maximize worksheet icon
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Closing Comment

by:ArtG2521
ID: 39702628
Well, byundt it worked!  I feel like....DOH! I'm an idiot
Thanks for the simple, yet elegant solution! LOL
0
 
LVL 80

Expert Comment

by:byundt
ID: 39702638
Excel 2013 makes it much harder to have the type of problem you encountered because the application pane is designed to display one document at a time. Excel 2010 and earlier are designed to display more than one document. As a result, they have the pane sizing controls that both create and fix the problem you encountered. I've been bitten by it myself :-)

Brad
0
 

Author Comment

by:ArtG2521
ID: 39702978
Thanks for that tip.

I am also NOT a fan of Microsoft doing away with Office as an installed program and going with a cloud based program.  I don't mind the cloud for some things, but I always want the option of a fully installable program.
0
 
LVL 80

Expert Comment

by:byundt
ID: 39703189
Office 365 is not a cloud-based program. Rather, it is an annual subscription for programs that are installed on your desktop or laptop computer.

Like any software developer, Microsoft wants to increase revenues. That perfectly good copy of Office 2007 that you are using isn't generating any new revenue for Microsoft, so they want to encourage you to upgrade to the latest. The annual subscription is a way for them to reduce your up-front cost for the upgrade and encourage you to keep current.

In the future, you will see features added more frequently (several times a year) to Office 365, but only once every three to four years for regular Office. You may also see a number of features be exclusive to Office 365.

A quote from Star Trek TNG applies to this situation: "Resistance is futile."  Microsoft is not alone, as other developers (Adobe, Symantec, McAfee, etc.) are also pushing towards a subscription business model. As a power-user of Excel, I plan to purchase Office 365 myself--even though I have perfectly good copies of Office 97 through 2013. I have to go where the features are.

Brad
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

This article will show you how to use shortcut menus in the Access run-time environment.
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now