Prob. in Opening Hiden Worksheet

[TV Muralidharan]

Dear Sirs

I am one of the regular users of MS Excel

I had run into a problem, when I was working on only one
XL file, i tried to hide the file by
giving the following command

Window
Hide

Then inadvertantly I also closed XL

Now I am unable to open the file at all

When I attempt to open the file, I get a msg to the
following effect

This program has performed an illegal operation

Close

help

Debug

Can u please let me know if there is anyway by which I
can open this file ? It is also password protected

I shall be happy to have your expert opinion on this

Please reply to me in my mail ID.

Thanks and regards

 

[Shailesh Shah]

Hi,

See below post by Jan Karel Pieterse :
----------------------------------------------------------
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