Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
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