excel 2002

[Lisa]

I had made a copy of a worksheet about 2 weeks ago for
backup and today my computer crashed. After installing
everything my worksheet keeps saying "unable to read
file". HELP!!!!!!!!!!!

 

[Jan Karel Pieterse]

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

 

[Guest]

Hi, I don't mean to sound stupid but what do you mean by
set calculation to manual, This whole crash tonite has
been a nightmare so any help would be great.

-----Original Message-----
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-----
I had made a copy of a worksheet about 2 weeks ago for
backup and today my computer crashed. After installing
everything my worksheet keeps saying "unable to read
file". HELP!!!!!!!!!!!
.

.

 

[Jan Karel Pieterse]

Hi,

Open Excel, choose Tools, options. CLick the Claculation
tab and select "Manual".

Don't forget to set it back to Automatic when you're done.

Regards,

Jan Karel Pieterse
Excel TA/MVP

 

[Lisa]

did everything except the link because I am not sure on
how to do that , also when doing a search on microsoft
that said their was a fix to install for this but for the
life on me I cannot find it. The fis info is in Microsoft
Knowledge Base Article - 812384. I really need to
recover this file so please any help!!!

 

[Jan Karel Pieterse]

Hi Lisa,

I really need to
recover this file so please any help!!!

ZIP it and send it to my email address:

j k p i e t e r s e AT n e t s c a p e . n e t

Regards,

Jan Karel Pieterse
Excel MVP