Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

Excel file does not open

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robert - 28 Sep 2007 09:36 GMT
My Excel file with the proper password does not open. If I type password,
Excel opens with top bar: Microsoft Excel - [File name] . But it looks like
standard Excel without file (blank), most funcutions in the Groups is hidden
( also Show)
If the password is type wrong, Excel gives standard information:
Password is not correct. (...).
Please help.
Gary''s Student - 28 Sep 2007 16:43 GMT
If you first open the Excel application and then from the application try:

File > Open...

what happens??
Signature

Gary''s Student - gsnu200747

> My Excel file with the proper password does not open. If I type password,
> Excel opens with top bar: Microsoft Excel - [File name] . But it looks like
[quoted text clipped - 3 lines]
> Password is not correct. (...).
> Please help.
Robert - 04 Oct 2007 12:24 GMT
The same story. It asks for password. After typing in name of the file is on
the top bar but Excel working area is blank.

> If you first open the Excel application and then from the application try:
>
[quoted text clipped - 9 lines]
> > Password is not correct. (...).
> > Please help.
Dave Peterson - 04 Oct 2007 13:33 GMT
You'll want to check a few things to see if the file really opened.

I use this:
Try to open the file
hit alt-f11 to see the VBE (where macros live)
hit ctrl-r to see the project explorer (like windows explorer)
Do you see your workbook's project in that window?
You should see something like:
VBAProject (Yourworkbooknamehere.xls)

If you don't see that, then your workbook did not open.

If you do see this, then close the VBE and go back to excel.

Try:
Window|arrange|Tiled
(Maybe the worksheet window is just off the visible screen)

If that worked, then resize the window the way you like.  (This can be caused by
the file being opened and saved by users with different display resolutions --
laptops especially!)

If that didn't work, maybe the workbook is opened, but hidden.
Try Window|Unhide
If you see the name of the workbook there, select it to unhide it.

====
If the workbook didn't open (when you checked in the VBE), I'd try this:

Close excel
start windows in safe mode
Windows start button|run
excel /safe
File|Open yourfilenamehere.xls

If it opens ok here, maybe you have a macro that's disturbing the opening of the
file.  Opening excel in safe mode will stop that macro.

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

> My Excel file with the proper password does not open. If I type password,
> Excel opens with top bar: Microsoft Excel - [File name] . But it looks like
[quoted text clipped - 3 lines]
> Password is not correct. (...).
> Please help.

Signature

Dave Peterson


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.