Hello. Approx. 2 months ago I upgraded from Excel 2000 to Excel 2003.
Since that upgrade, I'm facing some recurring errors which I have never
encountered while using Excel 2000.
I have an Excel file approx. 7 meg in size, which has approx. 25 modules
(each one under 64k easily). The file's main purpose is to store records,
which change almost daily. I have plenty of system memory (512) and
plenty of hardware space (over 40 gig available).
I have used this same file for months previously with the 2000
version but am now finding that after working with it for approx. 3
hrs. and then while attempting to save the file, one of two messages
appears. Either "File not saved" or "Catastrophic failure". No details
as to why. Typically I have saved the file so that it is compatible with
Excel 2003, 2000 and earlier versions. But these same error messages
occur when I attempt to save the file just as Excel 2003 format.
No external links, no shared Workbooks. The Svae Auto Recover
option is not on; I've never needed it before.
I have Windows XP with all the Service Packs and patches.
I run McAfee Virus Scan routinely and there is no virus on my
machine. (Also, no spyware).I can run other apps besides Excel for
hours without any glitches whatsover. And, when running Excel, it is
the only app I have activated.
All the operations within the Excel environment run fine while I
have the file in question up. It is only when I save the file that
the error messages above arise. This has happened twice before in
the past. It seems that Excel has a nasty, "bad hair day" and just
will not let me save the file with the changes I have made. To over-
come this in the past, I have had to eventually re-compose the xls
file into a new one. That is, copy sheet for sheet and macro for
macro, over to a new Workbook, and save the new Workbook in
increments. I certainly do not want to continually re-build my Work-
book over and over again. And I'm getting frustrated as to this
happening and not knowing why.
I tried getting help from MS Tech support but that was a grand waste
of time.
After purchasing the Excel 2003, I read repeatedly on the web that
the upgrade was basically not worth the money. And I am now finding
myself in agreement.
I'm wondering -- are these type of file save errors par for the course
with Excel 2003 ? Have you ever encountered them and do you know
their source ? What can I do to prevent this from happening ?
I truly appreciate your help/insight on this matter.
Thank you.
Ken
Since that upgrade, I'm facing some recurring errors which I have never
encountered while using Excel 2000.
I have an Excel file approx. 7 meg in size, which has approx. 25 modules
(each one under 64k easily). The file's main purpose is to store records,
which change almost daily. I have plenty of system memory (512) and
plenty of hardware space (over 40 gig available).
I have used this same file for months previously with the 2000
version but am now finding that after working with it for approx. 3
hrs. and then while attempting to save the file, one of two messages
appears. Either "File not saved" or "Catastrophic failure". No details
as to why. Typically I have saved the file so that it is compatible with
Excel 2003, 2000 and earlier versions. But these same error messages
occur when I attempt to save the file just as Excel 2003 format.
No external links, no shared Workbooks. The Svae Auto Recover
option is not on; I've never needed it before.
I have Windows XP with all the Service Packs and patches.
I run McAfee Virus Scan routinely and there is no virus on my
machine. (Also, no spyware).I can run other apps besides Excel for
hours without any glitches whatsover. And, when running Excel, it is
the only app I have activated.
All the operations within the Excel environment run fine while I
have the file in question up. It is only when I save the file that
the error messages above arise. This has happened twice before in
the past. It seems that Excel has a nasty, "bad hair day" and just
will not let me save the file with the changes I have made. To over-
come this in the past, I have had to eventually re-compose the xls
file into a new one. That is, copy sheet for sheet and macro for
macro, over to a new Workbook, and save the new Workbook in
increments. I certainly do not want to continually re-build my Work-
book over and over again. And I'm getting frustrated as to this
happening and not knowing why.
I tried getting help from MS Tech support but that was a grand waste
of time.
After purchasing the Excel 2003, I read repeatedly on the web that
the upgrade was basically not worth the money. And I am now finding
myself in agreement.
I'm wondering -- are these type of file save errors par for the course
with Excel 2003 ? Have you ever encountered them and do you know
their source ? What can I do to prevent this from happening ?
I truly appreciate your help/insight on this matter.
Thank you.
Ken
