Members
Stats
  • Total Posts: 28531
  • Total Topics: 8240
  • Online Today: 963
  • Online Ever: 51419
  • (01. January 2010., 10:27:49)












Author Topic: Excel data lost for work.  (Read 1326 times)

0 Members and 1 Guest are viewing this topic.

MarkusHakala

  • SCF Newbie
  • *
  • Posts: 2
  • KARMA: 1
  • Gender: Male
Excel data lost for work.
« on: 13. March 2016., 17:13:57 »
I have several old excel files that got corrupted when a server had a power surge. They were being used on a Mac 10.6 client and I have tried to fix with disk utility, many excel file repair packages on mac and pc and online, tried also opening in alternate software like open office and JMP to no avail. Is there any hope for this data?

Samker's Computer Forum - SCforum.info

Excel data lost for work.
« on: 13. March 2016., 17:13:57 »




Samker

  • SCF Administrator
  • *****
  • Posts: 7206
  • KARMA: 291
  • Gender: Male
  • Whatever doesn't kill us makes us stronger.
    • SCforum.info - Samker's Computer Forum
Re: how to recover corrupted excel files on Mac
« Reply #1 on: 13. March 2016., 20:32:43 »
Hi Markus,

For brief help, We need to know, which Excel version you use ??

Also, kindly checks:

... one older SCforum's topic with "similar" problem: http://scforum.info/index.php/topic,10143.0.html

... and instructions from official pages: https://support.office.microsoft.com/en-gb/article/Repairing-a-corrupted-workbook-7abfc44d-e9bf-4896-8899-bd10ef4d61ab?CorrelationId=b068cedc-7840-4c2c-9210-77504489d482&ui=en-US&rs=en-GB&ad=GB

cya later,

S.

devnullius

  • SCF VIP Member
  • *****
  • Posts: 3507
  • KARMA: 152
  • Gender: Female
    • SCForum.info
Re: Excel data lost for work.
« Reply #2 on: 14. March 2016., 07:00:57 »
Sounds like you are out of luck... Especially after the disk check & repair tools, you should be able to access everything you see. If not, they are damaged. If the repair tools for office can't handle them, it looks like it's over :(

When it comes to corrupt Mac file systems, to my surprise there are a few tools that should help (http://www.techrepublic.com/article/3-data-recovery-applications-for-os-x/ - untested). Normally, on Unix filesystems, when you remove a file, it's gone. At least, I've always been told ;p

Sorry for the bad news, if you do manage to crack it, do let us know how :)

Devnullius
More information about bitcoin, altcoin & crypto in general? GO TO  j.gs/7385484/btc

Cuisvis hominis est errare, nullius nisi insipientis in errore persevare... So why not get the real SCForum employees to help YOUR troubled computer!!! SCF Remote PC Assist http://goo.gl/n1ONa9

justesen

  • SCF Newbie
  • *
  • Posts: 3
  • KARMA: 1
  • Gender: Male
Re: Excel data lost for work.
« Reply #3 on: 22. March 2016., 15:18:00 »
When an Excel file is corrupted, then you can try several methods to recover it:
1. First of all, you can try to repair the file manually in Excel, as follows:
(1) On the File menu, click Open.
(2) In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
(3) Click Open and Repair, and then choose which method you want to use to recover your workbook.
You may find more information about this at:
http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010097017.aspx?CTT=1 (for Excel 2007)
http://office.microsoft.com/en-us/excel-help/repairing-a-corrupted-workbook-HA010342840.aspx?CTT=1 (for Excel 2010)
http://office.microsoft.com/en-us/excel-help/repair-a-corrupted-workbook-HA102749554.aspx?CTT=1 (for Excel 2013)

justesen

  • SCF Newbie
  • *
  • Posts: 3
  • KARMA: 1
  • Gender: Male
Re: Excel data lost for work.
« Reply #4 on: 22. March 2016., 15:25:19 »
2. If method 1 fails, there are still several methods to recover your Excel file manually with Excel, including writing a small VBA macro, as below
http://office.microsoft.com/en-us/excel-help/repair-a-corrupted-workbook-HA102749554.aspx?CTT=1#_Toc337637262
3.For xlsx files, they are actually a group of files compressed in Zip file format. Therefore, sometimes, if the corruption is only caused by the Zip file, then you can use Zip repair tools to repair the file, as follows:
4.1 Assuming the corrupt Excel file is a.xlsx, then you need to rename it to a.zip
4.2 Start WinRAR, go to "Tools > Repair Archive" to repair a.zip and generated a fixed file a_fixed.zip.
4.3 Rename a_fixed.zip back to a_fixed.xlsx
4.4 Using Excel to open a_fixed.xlsx.
5. If all above methods do not work, then you may try third-party tools such as Excel Recovery Toolbox at http://www.oemailrecovery.com/excel_recovery.html
   It provides a free download version so that you can try to see if the data you want can be recovered or not. Good luck!


MarkusHakala

  • SCF Newbie
  • *
  • Posts: 2
  • KARMA: 1
  • Gender: Male
Re: Excel data lost for work.
« Reply #6 on: 25. March 2016., 11:56:52 »
Thank you all for your advice! The issue has been resolved.

 

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Name: Email:
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image
Type the letters shown in the picture:
Second Anti-Bot trap, type or simply copy-paste below (only the red letters):www.scforum.info:

Enter your email address to receive daily email with 'SCforum.info - Samker's Computer Forum' newest content:

Terms of Use | Privacy Policy | Advertising