c0000005 (access violation)


T

Ted

I have one file that crashes my Excel 2000 sp-3. Dr.
Watson lists it as "c0000005 (access violation)". This
began after I pasted info from my online brokerage account
to a new worksheet in an existing workbook. Is there any
way I can correct this or delete the offending worksheet
without deleting the remainder of the workbook?
Thanks
 
Ad

Advertisements

J

Jan Karel Pieterse

Hi Ted,
Is there any
way I can correct this or delete the offending worksheet
without deleting the remainder of the workbook?

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.

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

Regards,

Jan Karel Pieterse
Excel MVP
 

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

Top