Link to home
Start Free TrialLog in
Avatar of USAHR
USAHR

asked on

My Excel workbook keeps crashing and I need help!

I have an extensive work book that containers many pages and links that allow us to navigate between them all. It keeps crashing lately and we are unsure as to why. The error starts when trying to open the file and gives the error "Excel found unreadable content in 'usabook21.xls'. Do you want to recover the contents of this workbook? If you trust the source of this workbook click yes" . Ic hoos yes then get "Repairs to 'usabook21'- Errors were detected in 'usabook21' but Microsoft excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent." Then below that reads "Damage to the file was so extensive that repairs were not possible. Excel attempted to recover you formulas and values, but some data may have been lost or corrupted" Then it gives me a link to click to view the log file listing repairs, that reads. "Microsoft office Excel File repair log. Errors were detected in file (file destination) the following is a list of repairs: Damage to the file was so extensive that repairs were not possible. Excel attempted to recover you formulas and values, but some data may have been lost or corrupted." And then after all that info if I click the close box on the error box it brings up all the data of the workbook but no formatting or links. Any idea what might be going on or how i may fix it? We copy the file regularly and have been loading a working version until it goes again. Thanks everyone for the help.
Avatar of Ignatius_A
Ignatius_A
Flag of United Kingdom of Great Britain and Northern Ireland image

I recommend reverting to a backup taken before this became an issue. It sounds like the file has been seriously mashed.
Avatar of USAHR
USAHR

ASKER

We have done that a few times. It works for a few days and then the problem randomly happens again within a few days to a week. Would it serve us better to start a new workbook and copy data from that one over?
ASKER CERTIFIED SOLUTION
Avatar of patrickab
patrickab
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of USAHR

ASKER

Thanks for the help, I didn't realise that excel was fussy about multi-user files, which is the purpose of the workbook we have a customer service department pulling info off of it all day so I think we will for now just continue backing up the file daily until we get something else in place.
USAHR - Thanks for the grade - Patrick