Hi Vaishnavi,

I see that you are facing with an Excel corruption error “we found a problem with some content. Do you want to recover ?” . After being on many forums and Q & As, I found out that this happens mostly in large sized Excel files or files with complex formulae. Please don’t worry, there are many workarounds to fix this. I am sharing them below:

Tip #1: Repair Corrupt Excel File”

1. Click on the “ File” menu, and then tap Open.
2. Then, navigate to the location where the corrupt Excel file is saved.
3. Click on arrow sign available next to Open button to select Open and Repair option.
4. Next, click “Repair to recover maximum possible data”.
5. If the repair is not able to recover the data from the workbook, select Extract Data to extract all possible formulas and values from the workbook.

Tip #2: Use External References to Link to the Damaged Workbook

Follow these steps:

1. In Excel, click File> > Open.
2. Go to the folder where the corrupt file is saved.
3. Right click on the file, select Copy, and then click on Cancel.
4. Click on File and then New.
5. Under the New option, click on Blank workbook.
6. In the cell A1 of new workbook, type “ =File Name!A1 “
7. If the Update Values dialog box appears, click the corrupt workbook, and choose”OK.”
8. If Select Sheet dialog box appears, click the appropriate sheet, and then click OK.
9. Select cell A1.
10. Next, click on Home, and then click Copy.
11. Starting in cell A1, select the area approximately the same size as that of the cell range that contains data in the damaged workbook.
12. Next, click on  Home and select Paste.
13. Keep the range of cells selected, click on Home and then Copy.
14. Finally, click on Home, click on the arrow associated with Paste and under Paste Values click on Values.

This will remove the link to the corrupt workbook and will retrieve data. But, keep in mind, the recovered data will no longer contain formulas or calculated values.

You can check out this thread https://social.technet.microsoft.com/Forums/Lync/en-US/e5692c4a-924d-44a5-985b-7878f3eb26de/corrupted-excel-file-repair?forum=excel]

Hi,

I was not able to understand which table exports and opens fine and which one gives error when trying to open after exporting. Also, do you try to export the WebDataGrid or igGrid ? Please provide more details and it would be best if you could provide a sample that exports a corrupted excel file. Then I will be bale to investigate and suggest accordingly.