Export to Excel - File corrupted

Export to Excel - File corrupted

Posted by: seann on 4 August 2017, 6:07 am EST

• 

  seann

  • Post Options:
  • Link
    Copy

  Posted 4 August 2017, 6:07 am EST

  I am running Office 2003 SP2.
  
  
  
  I am exporting data from Active Report 1.0 SP2 within VB6 SP5. The exported excel file can be opened by Office 2003 SP2.
  
  
  
  
  
  
  
  I apply Office 2003 SP3 and suddenly the same exported file cannot be read. Excel informs me the file appears to be corrupt and requires a repair procedure. This procedure does not repair the file.
  
  
  
  
  
  
  
  I applied Active Reports v2.0 SP5. It does not resolve my problem either. I get the corrupt file message with both Office SP2 and SP3. I cannot explain the sudden problem with Office SP2 even after it proved to work. I am not sure if a hotfix or some other update causes the Office SP2 change.
  
  
  
  
  
  
  
  Any assistance will be appreciated as i have some irate clients.

• 

  via

  • Post Options:
  • Link
    Copy

  Posted 4 August 2017, 6:07 am EST

  http://www.datadynamics.com/forums/104611/ShowPost.aspx#104611

• 

  jackbotty8

  • Post Options:
  • Link
    Copy

  Posted 27 December 2017, 5:31 pm EST

  There are few manual tricks which can be used to repair Excel file. This article contains some useful information - http://wordpress.semnaitik.com/2014/03/05/repair-excel-file/

• 

  mittanniekm

  • Post Options:
  • Link
    Copy

  Posted 20 September 2018, 6:00 pm EST - Updated 30 September 2022, 2:24 am EST

  This article was quite helpful.

• 

  dazyparker123

  • Post Options:
  • Link
    Copy

  Posted 8 October 2018, 6:27 pm EST

  Best solutions to repair corrupt Excel file

  Open and Repair

  • "Open MS Excel
    
    File option
    
    Select Open
    
    Choose Excel file
    
    Select open and repair option
    
    Click on Repair
    
    "

  Open Excel in Safe Mode

  Press the CTRL key and open the Excel instance. You can also do this by using command prompt. Press Windows key+R and type excel /safe

  Try Excel file repair software
  
  You can also try a software to repair your corrupt Excel file. Read the review of the best excel file repair software from here: https://www.cybrary.it/0p3n/stellar-phoenix-excel-repair-software-review/