Sheets missing

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Hi

I have a strange problem. When one of my users launch certain worksbooks in
Excel all the sheets in the workbook are missing, and she can't see any
cells. If she mails this workbook to a coworker, the other person is able to
see all the worksheets on her machine.
I'm not able to find any setting locally on the machine that can explain
this behavior. As fas as I can se it is neiter dependent of the user
profile. Because when I log on to the machine with another account, this
same problem occours. This is Excel 2003, part of an Office 2003 Pro
installation.

/Andy
 
First thing I'd do is check to see if the workbook is actually opened.

On the worksheet menu bar, click on Window. Do you see the name of the workbook
at the bottom of the dropdown? If no, then the workbook isn't opening or it's
opening hidden (unlikely if others can open it ok).

But just to make sure, click on Window and then if Unhide is greyed out, it's
not hidden. If Unhide is available, click on it to see if the workbook name is
in there (and unhide it if it is).

If the workbook appears at the bottom of the Window dropdown, try Window|Arrange
and make it tiled. Then resize by hand. (The workbook's window could just be
off the visible window.)

If the workbook doesn't appear at the bottom of the Window dropdown, then maybe
it's the way that the user is opening the workbook.

Does File|open work ok, but double clicking on the filename in windows explorer
cause trouble?

If yes, then...

Sometimes one of these works:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.
 
Hi Dave

Things started to work when I changed the Tools|Options|General|Ignore other
applications (uncheck it)

Thanks.

/Andy
 
Back
Top