Corrupted file

[forexcel]

I have created a complicated spreadsheet using excel 2007. I shared it at onedrive so some friends can download it and use it also. When they open it they are got the message that file is corrupted (they are using excel 2010-2013-2016) and some formulas and conditional format was gone at some sheets. Then I let them edit it at my onedrive and everything was working fine. It was working just fine at their browser but when they downloaded it again same message appeared. Any idea what to do ?

 

[jtakw]

Hi,

Don't know if this will help.
After your friends download the file, what's the file extension?
Is it filename.xlsx? If it is, rename it as filename.xls and see if it works for them.

 

[Scott Huish]

If you're going to try that, I would recommend saving it in that format rather than just renaming it because .xlsx files are .zip files

 

[forexcel]

I cannot save it at .xml format. Some cells have plenty of conditional format rules more than are supported by excel's .xml format. I also don't think this is the issue since they are working it without problems using the excel's version for browser. The weird is when they are downloading to use it with the desktop version they are getting message that file is corrupted and if they repair it formula's and functionality are gone

 

[jtakw]

I Still think you should give my suggestion in Post #2 a try.
I'm No asking you to Save your file in a different format.
I'm saying, have your friend/friends download the file, check and see if the file extension is other than xls
If it is, Change it to xls
Try to open the file again.
If it Doesn't work, No Harm Done, as we're Not changing your Original File.

Again, I Don't know if this will help, but I've had this happen to me several times where a file was created by an Older version of Excel, uploaded to the Cloud, then when I downloaded it, it won't open (saying the file extension doesn't match or the file is Corrupted), I changed the extension from xlsx to xls then it worked.

 

[forexcel]

I have tried it and still waiting response from friends

 

[forexcel]

I Still think you should give my suggestion in Post #2 a try.
I'm No asking you to Save your file in a different format.
I'm saying, have your friend/friends download the file, check and see if the file extension is other than xls
If it is, Change it to xls
Try to open the file again.
If it Doesn't work, No Harm Done, as we're Not changing your Original File.

Again, I Don't know if this will help, but I've had this happen to me several times where a file was created by an Older version of Excel, uploaded to the Cloud, then when I downloaded it, it won't open (saying the file extension doesn't match or the file is Corrupted), I changed the extension from xlsx to xls then it worked.

It didn't work