PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes excel file won't open

Reply

excel file won't open

 
Thread Tools Rate Thread
Old 09-07-2003, 04:24 AM   #1
Lonnie Drouhard
Guest
 
Posts: n/a
Default excel file won't open


Whenever i try to open a certain file from my computer I
get a page fault error that reads in the "details":

EXCEL caused an invalid page fault in module EXCEL.EXE at
017f:301761ad.

All other excel files seem to open up fine. How do I
remidy this? Thank you,

Lonnie Drouhard
  Reply With Quote
Old 09-07-2003, 08:55 AM   #2
Jan Karel Pieterse
Guest
 
Posts: n/a
Default Re: excel file won't open

Hi,

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 TA/MVP

>-----Original Message-----
>Whenever i try to open a certain file from my computer I
>get a page fault error that reads in the "details":
>
>EXCEL caused an invalid page fault in module EXCEL.EXE at
>017f:301761ad.
>
>All other excel files seem to open up fine. How do I
>remidy this? Thank you,
>
>Lonnie Drouhard
>.
>

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off