• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel File Corrupt

Rajender

Member
Hi All,

I have a excel file in .xlsb format located in our shared drive.
and out of 10 times its corrupt almost 5 times while saving.

Can anybody suggest any reasons why file corrupt so frequently ?

Thanks in advance.

Regards,
Rajender
 
Hi Rajender,

Could you please give more details so it will help experts (not me) to help you.

1) What is the file size.
2) Does the file contains macro
3) Is the file formula heavy
4) What do you mean by "Corrupt", you can not save the file, close it, re-open it & unsaved data is still there. Or
You can not even open the file.

5) Try switching the calculation to Manual mode (Short Cut Alt T O) and see if it makes any difference.

P.S. - These links might help you

http://www.wikihow.com/Recover-a-Corrupt-Excel-File

http://office.microsoft.com/en-in/excel-help/repairing-corrupted-files-in-excel-HA001034656.aspx

http://www.pcadvisor.co.uk/how-to/software/3449925/restore-corrupted-excel-file/

http://chandoo.org/forums/topic/saving-a-file
 
Last edited:
1) What is the file size. approx 4.6 MB
2) Does the file contains macro no macro
3) Is the file formula heavy vlookup formula & sumifs formulas there with in sheet
4) What do you mean by "Corrupt", you can not save the file, close it, re-open it & unsaved data is still there. Or
You can not even open the file. after saving the file when I am re-opening the file its shows first repair options and when i clicked on save options a new msg box showing unable to repair the file and I then that file unable to open.

5) Try switching the calculation to Manual mode (Short Cut Alt T O) and see if it makes any difference. no difference still unable to open the file while re-open it.
 
Back
Top