open excel

[Guest]

hi

I have a problem to open old excel file which made in MS OFFICE 97

AT PRESENT I USE MS OFFICE 2000 STANDARD WITH WINDOWS 2000 PROF.

THIS EXCEL FILE IS STILL OPEN IN OFFICE 97
THE ERROR IS DEVICE I/O ERROR

 

[Jan Karel Pieterse]

Hi Ani,

I have a problem to open old excel file which made in MS OFFICE 97

AT PRESENT I USE MS OFFICE 2000 STANDARD WITH WINDOWS 2000 PROF.

THIS EXCEL FILE IS STILL OPEN IN OFFICE 97
THE ERROR IS DEVICE I/O ERROR

Sounds like a problem with a userform to me. Does the file contain any?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Guest]

hi there is no problem in disk i/o
the excel contain a good number of sheets
some containing macro

 

[Jan Karel Pieterse]

Hi Ani,

hi there is no problem in disk i/o

I know.

the excel contain a good number of sheets
some containing macro

Does any of the VBA project(s) contain userforms?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Guest]

hi JAN
yes
few of the sheets contain macro

Hi Ani,


I know.


Does any of the VBA project(s) contain userforms?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Jan Karel Pieterse]

Hi Ani,

yes
few of the sheets contain macro

If you select all worksheets (click first, hold shift and click last
tab) and copy them to a new workbook (rightclick tab, select move or
copy, choose "New workbook" from the dropdown) and save that new file
(use a different name!), does the problem go away?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Guest]

Hi Jan

but there is problem in open the file
when i want to open the file the file giving the error and automaticaly
close the excel

 

[Jan Karel Pieterse]

Hi Ani,

but there is problem in open the file
when i want to open the file the file giving the error and automaticaly
close the excel

Check out this article:

http://www.jkp-ads.com/articles/CorruptFiles.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Guest]

Hi Ani,

Try this

Go to start->run.Type excel /safe.This opens excel in safe mode without any
startup addins or macros which might run as soon as the workbook opens.Try
to open your 97 excel file from here.If it opens successfully save it as a
Microsoft
excel 97/2000 file.Plz lemme know if this helps.

Rgds,
Ambrish