Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel
hi there is no problem in disk i/o
the excel contain a good number of sheets some containing macro "Jan Karel Pieterse" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel
hi JAN
yes few of the sheets contain macro "Jan Karel Pieterse" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel
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" wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel
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 "Jan Karel Pieterse" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enable automatic refresh | Excel Worksheet Functions | |||
CSV formatted files open odly in Excel 2000 | Excel Discussion (Misc queries) | |||
Open an existing excel speadsheet, opens Excel but not the file?? | Excel Discussion (Misc queries) | |||
How do i open excel doc in works? | Excel Discussion (Misc queries) | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) |