excel cannot open this one file

[nodoubt]

i dont know why today my excel cannot open this one and
only file... i've tried every resolution , reinstall, fix,
everything but come to no avail. this are the error when
im trying to open that file...

EXCEL caused an invalid page fault in
module MSO9.DLL at 017f:308d0ea9.
Registers:
EAX=02224d74 CS=017f EIP=308d0ea9 EFLGS=00010202
EBX=02224d74 SS=0187 ESP=0062a7fc EBP=0062a804
ECX=00000004 DS=0187 ESI=0091be20 FS=2b07
EDX=00000010 ES=0187 EDI=02224d74 GS=1c1e
Bytes at CS:EIP:
f3 a5 8b ca 83 e1 03 f3 a4 5f 5e 5d c3 8b 4d 10
Stack dump:
02224d7c 02224d04 0062a880 3006d525 02224d74 0091be20
00000010 00000000 00000000 00000001 00000001 000007da
0000002a 00000001 00000000 00000000


others work fine.. i still can open other excel file
without any error...

 

[Jan Karel Pieterse]

Hi Nodoubt,

i dont know why today my excel cannot open this one and
only file... i've tried every resolution , reinstall, fix,
everything but come to no avail. this are the error when
im trying to open that file...

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

 

[nodoubt]

Hello ,

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

i've tries this one and it works... it seems that 1 of my
worksheet is corrupt ( i didnt get any values from the
worksheet )... i hv to find an XP excel to try fix this
file.. thanks for your help...