Hardware

Ask something
Question Locked

How does Excel become corrupt?

0 helpful
4 replies

by netforce

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

One of our users has a spreadsheet on the network drive. The spreadsheet would open no problem, however it's when he tried to save it an error box popped up "send info to microsoft etc., then it would close.

Tried copying the file over to his local drive and renaming it......that did not work.

Then I had him create a new spreadsheet and copy each tab to the new spreadsheet.

It worked fine.

Question I have is how does the spreadsheet get corrupt?

Also if we were able to copy the data over successfully then I assume the data was fine but the file/shell was corrupt?????

Any ideas,

Thanks.

4 replies

by sgt_shultz

Hi, congrats on fixing your spreadsheet corruption and asking a pretty good question, IMHO. There is quite a bit to it. You did not mention your Excel version or office sp level so we can't help you specifically. Here is a place to start:
How to troubleshoot the source of the problem when you save files in Excel 2000 and they become corrupted
http://support.microsoft.com/kb/213951/en-us

by netforce

I just did a follow up with the user and looks like the links within that spreadsheet did not copy over correctly as he has inbedded apps, links, calcs.

So talking with another Excel guru in a different dept told me they are probably not using their "auto-calcs" or calc formulas enough within the spreadsheet.

Which he said leads to corruption.

Office version running is: Office 2003/SP2

User also stated day before he had no issue opening and saving to that spreadsheet.

And what I'm thinking is thank God for differential data backups.

I sincerely appreciate all your help.

by captbilly1eye

Make sure the spreadsheet file is not set to Read Only.
Also make sure the Windows Login User has Read & Write privileges to the folder on the network where the file resides.

This discussion is closed to new replies.