I have a user in our accounts dept who has an excel s/sheet he has used for some months. One day he just can't open it, illegal operation - program will be shutdown (useful message). He is using Excel 97.
He has emailed the file to me and I open it no problem - i;m Excel 2002 (XP).
The file doesn't contain links, it has 6 simple worksheets, with accounting data in it, fancy colours and so on. File is 2MB in size.
I have tried opening it on another PC running Excel 97 and same problem - illegal operation. So it's just Excel 97 that won't open the file - even though it was working until a couple of days ago
I have tried copying the data into another workbook and saving it, no joy. Also tried saving it in the Excel 95-2000 format in XP, this makes it about 4MB and still same problem.
If we remove some of the worksheets and re-save, it opens fine. So it seems to be the amount of data or the size of the file that it responsible or indeed some part of the workbook is corrupt.
Can anyone suggest a cure - or this a upgrade to Excel 2000 kind of thing.
He has emailed the file to me and I open it no problem - i;m Excel 2002 (XP).
The file doesn't contain links, it has 6 simple worksheets, with accounting data in it, fancy colours and so on. File is 2MB in size.
I have tried opening it on another PC running Excel 97 and same problem - illegal operation. So it's just Excel 97 that won't open the file - even though it was working until a couple of days ago
I have tried copying the data into another workbook and saving it, no joy. Also tried saving it in the Excel 95-2000 format in XP, this makes it about 4MB and still same problem.
If we remove some of the worksheets and re-save, it opens fine. So it seems to be the amount of data or the size of the file that it responsible or indeed some part of the workbook is corrupt.
Can anyone suggest a cure - or this a upgrade to Excel 2000 kind of thing.