Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Excel 2007 will not display sheets

Posted on 2013-12-06
Medium Priority
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!
Question by:ArtG2521
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 13

Expert Comment

ID: 39702570
Refer to:

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.
LVL 98

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
LVL 81

Accepted Solution

byundt earned 2000 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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.


Author Closing Comment

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

Expert Comment

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 :-)


Author Comment

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.
LVL 81

Expert Comment

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.


Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

705 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