Scan for file corruption?

I'm curious if such a utility exists that would scan a file (.xls and .xlsx in this particular case) to check for problems like file corruption / integrity.

I have a user that tells me he has problems with certain files (typically from a certain other user) whereas these files keep causing Excel to crash.  Getting information from this user is frustrating. At this time, I'm able to open these files on my computer without issue.

The files contain confidential pricing information on our product, so unfortunately I can't post them here.

User is using Office 2010 Prof on Windows XP Pro
Problems are not always reproducible - at least not yet.
User's computer is free from malware - I ran various scans on it just a few days ago when it was on my desk.
LVL 14
GeisrudSystems AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raymond PengSystems EngineerCommented:
Microsoft has the native open / repair feature when you try File > Open.  

To troubleshoot - have you tried logging as yourself on their computer and have you tried logging in as the user on a different computer?  This helps determine if it's a profile issue or computer issue.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Glenn RayExcel VBA DeveloperCommented:
There are various scenarios where end users say that "Excel crashes" but are in fact unique events.  Without knowing the full circumstances and error messages, if any, it's hard to say.

I have to say that if I were in your situation and saw this firsthand on the user's machine, AND I could also open these files on another machine with Excel 2010, I would first attempt a Repair (via Control Panel, Add/Remove Programs) or a re-install of Excel/Office.

Good Luck!
-Glenn
0
GeisrudSystems AdministratorAuthor Commented:
l33tfob:
I haven't had the opportunity to log into that computer under a different profile, or that user on another computer.  I will as soon as possible.

I did try that open/repair option and it did find errors with 4 of the 5 files I have that my user has had issues with.  The error log provides little useful information

 
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error057000_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\joer\Desktop\2012 - Folding Leg VT FC .xlsx'</summary>-<additionalInfo><info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info></additionalInfo></recoveryLog>

Open in new window

0
GeisrudSystems AdministratorAuthor Commented:
GlennLRay:

I certainly understand how hard it is to work with limited information.  When I asked the user "what specifically were you doing with the file when it crashed" his response was "General Work".

I'll give that repair install a shot also.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.