Password protected Excel file crashes - but worked ten minutes ago

  • Thread starter Thread starter Dr. Dave
  • Start date Start date
D

Dr. Dave

Hello all - have a question:

I have a password protected Excel file that does not contain any
macros that was working fine when I saved and closed it before lunch.
However, now when I open it, I am prompted for my password, and after
entering it, Excel crashes without ever displaying the file. Needless
to say, this sucks!

I am using Office 2000 SR-1 with all the service packs (Excel version
9.0.6926 SP-3).

On Windows XP, I get the "Send error report" prompt, which doesn't
give me real detailed info on what caused the problem. Excel crashes
with this file after I click "Don't send" for the error report.

On Windows 2000, I Excel simply vanishes after I type in the password.
Arrgh!

Both machines have the latest updates for both operating system and
Norton AntiVirus. No viruses are present on the machine.

I can open other Excel files just fine.

This may or may not matter but the last major operation I did in Excel
was adding another worksheet to my workbook file and then entering
data on it. I have over a dozen worksheets in the workbook (perhaps
closer to two dozen), but the file itself is only 200K.

I hope this is enough info for someone to help me out!

Thanks in advance,

Dr. Dave
 
Since you use Norton AV my first suggestion is to disable the "Office
Plug-in" option in Norton Options under the Miscellaneous section.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Add this newsgroup to Outlook Express!
news://msnews.microsoft.com/microsoft.public.office.misc

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
Hi Dr. Dave,

Also try this methods posted by Jan Karel Pieterse in this
NG.

------------------------------------------------------

Options to try and open a corrupt file

- Set calculation to manual
- open the file, but disable macros (assuming you've set
macro security
to medium: Tools, Macro, security)
- As soon as you've clicked the disable macros button,
press
control-pageup or control-pagedown, thus changing sheets.

If that does not work, try creating a link to the file:

='c:\my documents\[MyFileName.xls]Sheet1'!A1

and copy right and down. This at least gets you the
worksheets values.

if you don't know the sheet names, enter this:

='C:\PathToFile\[MyFileName.xls]'!A1

and press enter

If XL (2000) is able to extract them, it will prompt you
for a sheet
name.

Sometimes the Excel viewer, Word or even Internet explorer
(v5) enables
you to open the file and copy information out of it.

If the file is not protected, maybe you can open it with
OpenOffice
(www.Openoffice.org).

Also, Excel XP can sometimes repair XL files with trouble.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
----------------------------------------------------------
end of post



Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/
 
Back
Top