Western Digital Corporation WD ShareSpace WDA4NC80000 - NAS Server Logo
paul young Posted on Jan 23, 2013
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Corrupt excel 2010 file

Whilst using mionet with remote excel files - the files have become corrupt

5 Answers

Addison Philip

Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

Governor:

An expert whose answer got voted for 20 times.

New Friend:

An expert that has 1 follower.

  • Contributor 39 Answers
  • Posted on Feb 15, 2013
Addison Philip
Contributor
Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

Governor:

An expert whose answer got voted for 20 times.

New Friend:

An expert that has 1 follower.

Joined: Dec 28, 2010
Answers
39
Questions
0
Helped
13143
Points
54

Here are some additional methods:

Opening the file with Open or Libre Office: It has been observed that Open & Libre office are able to open corrupt MS Excel files. These programs are free to download.

Repairing the file with Excel repair software: There are so many data recovery companies that claim they can repair badly corrupt MS Excel files created in MS Excel 2010.

Hans Pedersen

Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

  • Master 3,606 Answers
  • Posted on Jan 29, 2013
Hans Pedersen
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Joined: Feb 15, 2011
Answers
3606
Questions
0
Helped
2231228
Points
8683

1 - Using "Open and repair"

Microsoft Excel has a built-in repair tool for corrupted files. To access it, go to File and Open. A menu will pop up in which you'll have to select the file you want to fix and then choose "Open and repair" from the dropdown menu. This will open a dialogue box in which you can pick between the repair option (which will recover as much information as possible) and the extract option (that will copy values and formulas). The two alternatives combined should work fine to save your work.

2 - Saving the file to a different format

If you can open the file but you can't modify it or save the changes, you should use this method. You'll have to save the file to a different format (such as SYLK or HTML) via the "Save as" menu. Once you've done this, you'll have to open the recently saved file and then save it once again (but this time, you'll have to choose the Excel Workbook as the format). By doing this, you'll be creating a fresh new file with all the data from the corrupted file.

3 - Opening the file in Microsoft Word

This option is only available for the people that have the Microsoft Excel converter installed on their PC (it can be downloaded from the Microsoft website). You simply have to open the corrupted Excel file with Word. However, you should know that this method only works for retrieving data (all the structures from the sheet will be gone, such as formulas and macros).

4 - Altering the Calculation option

If your file isn't opening at all you can try to adjust the calculation option. Simply open Excel in a blank workbook, go to the "Tools" menu and look for "Options". There you'll find the "Calculation" tab in which you'll have to look for the "Calculation" section and set it to "Manual". Click OK and then try to open the corrupted file once again.

5 - Linking the corrupted file

In this method, you'll have to link one cell of a blank worksheet to the corrupted workbook. Be sure to create the new worksheet in the same location as the corrupted file. Once you've done this go to the blank worksheet and enter the following in the A1 cell: <Filename>!A1. This will copy the data from the A1 cell of the corrupted file to the new sheet. In case it works, simply click "Edit" on the cell and select an area like the one covers the cell that contain data in the damaged file, and then click Paste. Then (and with the cells still selected) click Copy on the Edit menu.

Ad

Alexey Krenvalk

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Sergeant:

An expert that has over 500 points.

Champion:

An expert who has answered 200 questions.

  • Expert 419 Answers
  • Posted on Jul 07, 2013
Alexey Krenvalk
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Sergeant:

An expert that has over 500 points.

Champion:

An expert who has answered 200 questions.

Joined: Sep 18, 2007
Answers
419
Questions
0
Helped
309067
Points
517

Get back your excel files applying how to fix corrupt excel 2007
http://www.excelfilefix.com
This solution will help you completely restore the information

Anonymous

Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

  • Contributor 4 Answers
  • Posted on Apr 14, 2013
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

New Friend:

An expert that has 1 follower.

Joined: Apr 14, 2013
Answers
4
Questions
0
Helped
1358
Points
5

If your data did not recovered till now, i would suggest you to try Excel File Recovery Software when you search on Google you will find many results and all websites offering free trial version. One such utility is here.

http://www.recoverydeletedfiles.com/excel-file-recovery-tool.html

Thanks

Anonymous

Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

New Friend:

An expert that has 1 follower.

Hot-Shot:

An expert who has answered 20 questions.

  • Contributor 25 Answers
  • Posted on Mar 01, 2013
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

New Friend:

An expert that has 1 follower.

Hot-Shot:

An expert who has answered 20 questions.

Joined: Oct 12, 2012
Answers
25
Questions
0
Helped
14319
Points
26

Microsoft Excel is a well known spreadsheet application that stores data like tables, texts, date format, numerical, hyperlinks, texts, unique code etc. in Excel sheet. There are many reasons due to which these files get damaged and user face problems. RecoveryFix for Excel Recovery is the best tool that resolves all issues and gets back your all data from corrupt MS Excel file.


http://www.excelrepairtool.com


Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

Can you give an answer on 2010 excel I update fileon my workstation but another station has read only file open but does not refresh. Can you help.

The problem is the the remote work station has a copy of he original open. His version will only update when he reloads the document. Your updated version becomes the new version. His read Only is in RAM on his machine.

Hope this helps?
4helpful
4answers

Excel Corruption files

Without seeing the file, it is difficult to diagnose what is going on, but I will offer some ideas.

What version of Excel are you using? Are you using Excel 2003? Was the file you are trying to open created in Excel 2007 or Excel 2010. If so, it might be using the new format and therefore will not open in Excel 2003 and older.

It is possible the Excel file is data that was imported from a source in which Excel cannot import. Does the Excel spreadsheet contain any imported data?
Try to use: XLSX Viewer Tool here : http://www.xlsx.viewertool.com/
Those are the most likely causes of the corrupt data. Is every file you open in Excel corrupt, or just this one workbook? If it is just this one workbook, then, yes, it sounds like it is corrupted. If every file you open with Excel is corrupt, then your version of Excel could be corrupt, but that is unlikely.
2helpful
5answers

How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. Please...

Excel file can be repaired manually if it is less corrupted but Open and Repair program doesn't work if highly damaged due to corruptions. I searched for solutions to repair corrupt Excel file and found one solution which is full of information and provides a guaranteed solution. I am sharing this solution with all the users -Excel Repair Toolbox. Follow the exact steps given in this programm and you will be able to access the data. Download Microsoft Excel Repair tool
1helpful
3answers

Excel 2007 document recovery repeating document on Terminal Server

MS Excel File can get corrupted due to virus attack, missing MS office files, power failure and other possible reason that can be fixed by only use Stellar Phoenix Excel Recovery fix corrupt Excel (.XLS/.XLSX) files and restore everything (including charts, chartsheets, cell comments, worksheet properties etc.
2helpful
2answers

The file is corrupted in Excel 2007. What should i do?

Have you tried opening it up in another versions of Excel? Try 2003, 2010 or whatever. It can be effective.

Have you tried Open Office, Libre Office, Star Office and another? It can be useful too.

It`s possible the corruption is too bad. Have you used google to find any software? You can find both free or not, first are not so effective in my opinion. Try professional program, for example Recovery Toolbox for Excel.
https://excel.recoverytoolbox.com/
You can use the trial version and decide how useful is it in this case.
2helpful
8answers

I cannot open .docx and xlsx files.

The files extensions you have listed, .docx and .xlsx, are files that have been created using the Microsoft Office 2007 or 2010 suite of programs. Specifically .docx is a Microsoft Word document, and .xlsx is a Microsoft Excel spreadsheet. You will have to have either of the Microsoft Office programs mentioned, or you can also use the Open Office suite of programs. This is a free program that you can download at the following website:

http://www.openoffice.org/
3helpful
6answers

My excel 2010 file .xlsx was damaged or corrupted. how can i repair and getback

Use in-build "open and repair"utility of MS excel to repair damaged .xlsx files. Follow thesesteps to it

  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.

Most probably your problem may get fixsuppose due to any reason it can't fix your problem then use thirdparty excel repair softwarehttp://www.stellarinfo.com/excel-recovery.htm

3helpful
2answers

How to manually uninstall MioNet. Easy to answer!

Target is "C:\Program Files\MioNet\ARPMio.exe". There are no command line arguments. "Start in" directory is C:\Program Files\MioNet .
0helpful
1answer

Can't map network drive WD Blue ring edition

The Failed Mount issue is usually caused by Internet Security settings. The most common way to resolve it is to add the following files/ports to the exceptions list of your firewall(s) -- in some cases you will need to add it to the Windows Firewall, even if you have another Firewall installed as well:

MioNet.exe (C:\Program Files\MioNet\jvm\bin\MioNet.exe)
MioNetManager.exe (C:\Program Files\MioNet\MioNetManager.exe)
ServiceStatusGui.exe (C:\Program Files\MioNet\ServiceStatusGui.exe)

These ports are also required for MioNet to create a drive-letter for remote drives:
TCP In/Out 443
TCP In/Out 445
Not finding what you are looking for?

540 views

Ask a Question

Usually answered in minutes!

Top Western Digital Corporation Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

Brad Brown

Level 3 Expert

19187 Answers

Cindy Wells

Level 3 Expert

6688 Answers

Are you a Western Digital Corporation Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...