Excel Saving Errors With File Corrupted

We have an Excel time card program which a number of employees use.  

When they try to save the file to anywhere, they get the errors on the attached images.  Basically saying that errors were detected on the sheet and to repair it.  When you do try to repair it, it says the file is so badly damaged it cannot fix or save it.

But its not a bad file.  Its a read-only file on a network share.  Currently all but 3 people are unable to use this exact same document fine.  The people that cannot it just suddenly stopped working for them.  Just one day out of the blue they get this error.  Once they get the error I cannot figure out how to fix it.

I have tired copying the file to their desktop.  Tried remaking their profile.  Try patching Excel.  The only thing that worked so far has been to wipe the machine and reload.  Which I am not going to keep doing.  It just so happened this one user needed it for other reasons.

Any help would be appreciated.
1.png
2.png
3.png
LVL 1
Bryan_HeathAsked:
Who is Participating?
 
redmondbConnect With a Mentor Commented:
Bryan,

It's already an xlsm file.

That's why I'm suggesting turning it into an xls file.

Edit: Now my "D'oh" moment - save it as "Excel Binary Workbook (*.xlsb)". This has all the internal functionality of xlsm, it's just fast and more efficient.

Regards,
Brian.
0
 
redmondbCommented:
Hi, Bryan.

Assuming there's nothing sensitive/confidential in the file, please post a copy here.

You mentioned that for the people who can't use it (three or "all but three"?), the problem came on suddenly and for no apparent reason. Had the file been updated on the share immediately prior to this or has the file been unchanged since the problems started?

Which versions of Excel are in use? Operating systems?

Thanks,
Brian.
0
 
Bryan_HeathAuthor Commented:
I am not sure if I can or not.  There are somethings in there I don't think my company would like out there.

There are 20 or so users that use this.  3 cannot at this time.  They all have this exact same error.  Everyone else is fine.  Including me and my IT co-workers.

I should add that the problems did not start all at one time.  The first reported case was in Dec.  They were the ones that ended up getting wiped.  Then we had one in Feb, April, and then this month.  So it's not like the problem just started at the same time for these people.  Which makes it more ????

To my knowledge this program has not been updated, but we are not the managers of this program.  However when asked the person that is said no.

We have Excel 2007 & 2010 and the issues seem to be with 2010.  I don't think anyone with 2007 has complained.  I will have to double check.  OS is XP and 7.

I am thinking about deleting all there temp files and seeing if that helps.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
redmondbCommented:
Bryan,

If you check the Last Modified Date on the file you'll know whether it's been saved since the problem started.

At the moment, I'm leaning towards this being a file problem - I don't think I've ever come across a situation where a problem with the O/S or Excel has caused a problem in a single, "normal" file.

At this point, I'd usually suggest rebuilding the file - however judging by its content and number of sheets that would be a pain. So, as a quick and dirty test trying saving the file in the pre-2007 format ("Excel 97-2003 Workbook (*.xls)") and see if that format causes problems for your 3 users.

(Please note that this is a test not a workaround - it's entirely possible that the file is using functionality not supported by the earlier format.)

Edit: What are the temporary files?!

Thanks,
Brian.
0
 
Bryan_HeathAuthor Commented:
*DOH* Yeah, didn't think of that.  So it does show it was modified in Aug.  So there is a possibility that could be causing it.

Yeah rebuilding is not in the cards at this point.  It would take weeks and we are going to be replacing this with an online time card program next year.  So really that wouldn't be the best idea.

It's already an xlsm file.

Trying to remove the Windows temp file and any Office cached files just to see if for some reason its doing that.  Because the file is readonly and in a secure area it doesn't create the temp file there when you go to edit it.  It must make it some where else.
0
 
Bryan_HeathAuthor Commented:
Ok good point.  We will give that a shot.
0
 
Bryan_HeathAuthor Commented:
That worked.  We tried other extension and it didn't for some reason.  Honestly I don't get it but if it works then that's what matters at this point.

Thanks
0
 
redmondbCommented:
Thanks, Bryan.

I suspect that there was a minor corruption in the original file. Saving it as an xlsb was effectively a rebuild.

Regards,
Brian.
0
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.

All Courses

From novice to tech pro — start learning today.