If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel file unable to read from morning to afternoon
Here's one I'd like help figuring out. I've got a couple
of users with Excel 97 and 2K that save their files to their home directory on shared server drive. On two seperate occassions they both have been unable to open files in the afternoon they worked on earlier in tht moring on the same day. I am able to recover the files in Excel 2002 but loose formating. Server hard drive cheecks all integrity tests and it's been at least four weeks since the last time it happened to these two. Help on this would be appreciated. |
#3
|
|||
|
|||
Here is a copy of the Excel repair log when attempting to
recover the document in Excel 2002. Microsoft Excel File Repair Log Errors were detected in file '\\Servername\username\excel\excelfilename.xls ' The following is a list of repairs: Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted. Excel found errors that may cause some recovered data to be put in the wrong cells. Please check your recovered data carefully. .................................................. .......... What I don't understand is this user worked on multiple files yesterday morning and only two of the files ended up corupted. Ihad him check the others and he said they all opened and looked fine but two he could not even open. -----Original Message----- First, if it happens again, you may have better luck recovering more stuff with OpenOffice. (http://www.openoffice.org, a 60-65 meg download or a CD) But sometimes workbooks get corrupted. It might be time to recreate your workbooks. I haven't had that much experience with corrupted workbooks, but I did have a worksheet within a workbook that kept causing trouble. I was luck enough to rebuild (and replace) that one worksheet and all's well so far (knock wood!). wrote: Here's one I'd like help figuring out. I've got a couple of users with Excel 97 and 2K that save their files to their home directory on shared server drive. On two seperate occassions they both have been unable to open files in the afternoon they worked on earlier in tht moring on the same day. I am able to recover the files in Excel 2002 but loose formating. Server hard drive cheecks all integrity tests and it's been at least four weeks since the last time it happened to these two. Help on this would be appreciated. -- Dave Peterson . |
#4
|
|||
|
|||
I have no idea why two workbooks were corrupted and the rest weren't. I think
I'd be ticked off that two were--and happy that only two were. Corruption is really a workbook level event bg. (Although, you can damage excel enough so that it can't open any workbook.) So keep backups and find your installation CD--just in case! wrote: Here is a copy of the Excel repair log when attempting to recover the document in Excel 2002. Microsoft Excel File Repair Log Errors were detected in file '\\Servername\username\excel\excelfilename.xls ' The following is a list of repairs: Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted. Excel found errors that may cause some recovered data to be put in the wrong cells. Please check your recovered data carefully. .................................................. ......... What I don't understand is this user worked on multiple files yesterday morning and only two of the files ended up corupted. Ihad him check the others and he said they all opened and looked fine but two he could not even open. -----Original Message----- First, if it happens again, you may have better luck recovering more stuff with OpenOffice. (http://www.openoffice.org, a 60-65 meg download or a CD) But sometimes workbooks get corrupted. It might be time to recreate your workbooks. I haven't had that much experience with corrupted workbooks, but I did have a worksheet within a workbook that kept causing trouble. I was luck enough to rebuild (and replace) that one worksheet and all's well so far (knock wood!). wrote: Here's one I'd like help figuring out. I've got a couple of users with Excel 97 and 2K that save their files to their home directory on shared server drive. On two seperate occassions they both have been unable to open files in the afternoon they worked on earlier in tht moring on the same day. I am able to recover the files in Excel 2002 but loose formating. Server hard drive cheecks all integrity tests and it's been at least four weeks since the last time it happened to these two. Help on this would be appreciated. -- Dave Peterson . -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Application must be installed to run Error | Keith | Setup, Installing & Configuration | 1 | June 29th, 2004 03:02 AM |
corrupted excel 2000 file which is password protected | Ezra | General Discussion | 5 | June 14th, 2004 06:47 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
Cannot open large excel file | Niall Caslin | Worksheet Functions | 3 | October 29th, 2003 05:24 PM |
export excelsheet into text file | Mili | Worksheet Functions | 6 | October 23rd, 2003 07:22 PM |