My Excel workbook keeps crashing and I need help!

USAHR
USAHR used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I recommend reverting to a backup taken before this became an issue. It sounds like the file has been seriously mashed.

Author

Commented:
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?
USAHR,
>I have an extensive work book that containers many pages and links that allow us to navigate between them all.

The crucial word in that sentence is 'us'. The implication being that more than one person is using the workbook. The chances are that you are using it in 'shared' mode - at least some of the time. Very simply and starkly - don't. Here's my take on shared files:

"Excel does not handle 'Shared' workbooks reliably. They are often corrupted at random and apparently without cause. Clearly there is a cause but it has not yet been isolated and fixed by MS. There is nothing you can do to avoid shared workbooks corrupting. The ONLY thing that can be done is to make them single user.
 
To help you with the single user file system try adopting this approach instead. It does work rather well so it's worth doing. First make the file(s) single user. Second edit everyone's user profile in Excel - Tools/Options/General/UserName and in there put the person's name and telephone extension number. Then whenever you attempt to open a file that someone else is using, a dialogue box will pop-up telling you who is the current user - and it tells you their telephone extension number! The new user can opt to either call the current user or open the file as read-only.
 
I realise it seems odd that MS would have an unreliable feature in Excel but I'm afraid that's the way it is. If you must have simultaneous access then it would be wise to use a proper database. "
 
For Office 2007:  Office Button > Excel Options >Popular tab >User name
I hope that helps
Patrick

Author

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial