Excel won't open it's a blank page, after password

S

shannieboat

I opened an excel 2000 workbook, enabled marcos, entered password, window
closed and bottom bar says it's opening my page, done and then goes to a
blank grey screen. I've did this same procedure for years and never failed.
I can open other documents that are linked to this one with no problem but
cannot see the workbook. Any help would be greatly appreciated!
 
P

Piranha

Hi,
Did you try going to "Window" "Arrange" "OK"
Dave said:
I opened an excel 2000 workbook, enabled marcos, entered password,
window
closed and bottom bar says it's opening my page, done and then goes to
a
blank grey screen. I've did this same procedure for years and never
failed.
I can open other documents that are linked to this one with no problem
but
cannot see the workbook. Any help would be greatly appreciated!
Click to expand...
 
S

shannieboat

No, it does not show, nor is the option there to arrange window. I don't
understand as the bottom bar says opening the document and runs to the end of
it and then page appears blank. Any other ideas?
 
S

shannieboat

Yes, it does not show, nor is the option there to arrange window. I don't
understand as the bottom bar says opening the document and runs to the end of
it and then page appears blank. Any other ideas?
 
D

Dave Peterson

If you hit File|Print preview, do you see your worksheet?

If yes, then it's open, but off the screen.

Window|arrange|tiled will usually fix this.

But if the workbook has been protected with the windows option protected, then
you won't be able to move the windows.

Tools|Protection|unprotect workbook
(You may need to provide a password)

======
Maybe the worksheet's windows were hidden (but the file is still open)???

Is "Window|Unhide" available?
If yes, try it.

======
Maybe the workbook isn't really opening.
Try opening the workbook
then if you don't see it
hit alt-f11 (to get to the VBE--where macros live)
then hit ctrl-r (to see the project explorer)

This project explorer is very similar to windows explorer.

Do you see something like:
VBAProject (YourWorkbookNameHere.xls)

If you do, then the workbook is probably open--there is a very infrequent bug
that can continue to show this entry--but that usually occurs after you close
the workbook (if it happens at all).
 
Top