Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

Corrupt Workbooks


The process known as "Round Tripping" can remove links and other hidden formatting history within an Excel Worksheet.  This procedure may be used if you have a corrupt workbook.  It may also be used if the workbook is not converting to Values after the report has been run.

Procedure:

  1. Open the file, and do a Save as: 2003 Workbook .xml.
  2. Close out Excel, and open the file you just saved with the .xml extension
  3. Do a Save As to an .xlsx file format *
  4. Close out of Excel and reopen the workbook

* this procedure is also used when using Excel 2003 with the exception of the file extension being saved as a .xls file instead of an .xlsx file.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments