?
Solved

Excel Saving Errors With File Corrupted

Posted on 2012-09-04
8
Medium Priority
?
424 Views
Last Modified: 2012-09-21
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
0
Comment
Question by:Bryan_Heath
  • 4
  • 4
8 Comments
 
LVL 26

Expert Comment

by:redmondb
ID: 38401541
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
 
LVL 1

Author Comment

by:Bryan_Heath
ID: 38401890
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
 
LVL 26

Expert Comment

by:redmondb
ID: 38401937
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 1

Author Comment

by:Bryan_Heath
ID: 38401946
*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
 
LVL 26

Accepted Solution

by:
redmondb earned 2000 total points
ID: 38401966
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
 
LVL 1

Author Comment

by:Bryan_Heath
ID: 38401994
Ok good point.  We will give that a shot.
0
 
LVL 1

Author Closing Comment

by:Bryan_Heath
ID: 38422201
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
 
LVL 26

Expert Comment

by:redmondb
ID: 38422357
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question