My appointment can not be carried out.

[SienaRandolph]

I work with finance, and I have to work with excel tables. A couple of days ago, working on statistics, I need data for the past year. I could not open the file I needed. Office 2010 reported an error: Microsoft Excel has encountered a problem and needs to be closed. I have no idea how I can get my data from there?

 

[Hui]

Siena

Firstly, Welcome to the Chandoo.org Forums

First thing is copy the file to a safe place
simply so that if anything happens to it you have a backup

Next, do you have a backup?, Have you emailed it to anyone recently?, Put it on a Dropbox or Microsoft Drive etc ?

Have you tried opening it using the File, Open and Repair option


let us know how you go?

 

[pecoflyer]

If no macros are involved trying to open with OpenOffice sometimes works

 

[DanielSweeney]

Method, which means by using MS Excel

Try opening the .dbf file in Excel or other program that supports opening the .dbf format.

Once opened in Excel you should be able to view the file, delete any "bad data", and resave to a new name (with the .dbf extension).

Also possible to create a new table with the structure of the old table, append records from the old to the new. May salvage records until the corruption is encountered.