Resources For IT Professionals
Background: One of my clients had zipped the .excel files in on his local desktop and uploaded to SharePoint site. There files contains the project level information and was needed to extract after two years. When he clicked the file to open from SharePoint had encountered the issue.
Now the task begins of a SharePoint admin.
Troubleshooting:
Tried to open the file from SharePoint site, no go.
Downloaded the file on desktop of the client, no go.
Tried the same steps at my end, no success.
Strange this accessing file on SharePoint server also does give the same error.
With the above basic stuff, it was clear that it is something to deal with the zip file itself as it doesn’t seems to be SharePoint issue anymore.
Being a digger try to dig some more in it and seems like something to deal with the excel documents zipped may be was in protected mode.
Client was having no clue for this.
Resolution: Tried to find the Repair tool on the internet and million thanks to Christina Marley who created a zip file repair utility which when ran has repaired the file and is available for download here. Christina MarleyChristina Marley
http://gallery.technet.microsoft.com/The-Compressed-Zipped-d39407b2
Asked the user to download the files and repair them with the utility.
However, you can also find some other relevant repairing tools which may provide the evaluation version or you may need to buy the licence version of the tool.
http://www.diskdatarecovery.net/repair-zip/
If you feel any difficulty in understanding the tool or have any query I would be happier to help you.
Applied to: SharePoint 2007, WinZip, and WinRAR. Windows XP.
