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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
 
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?
 
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?
 
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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top