|
|
When I then open an Excel table it gives me an error message. "file error: data may have been lost"
This error message in Excel occurs if you are using Excel 2003 with Service Pack 3 applied, or Excel 2007.
Microsoft changed the internal XLS file format from SP3 of Excel 2003 which triggers this error. It's a known issue and we have scheduled an update of our product to address it.
Until the fix is available here are a few workarounds:
- Use a workstation that doesn't have Service Pack 3 applied to Excel 2003 (SP1 and SP2 are ok).
- Use a different spreadsheet program to open the XLS files. Such as 'OpenOffice' or 'StarCalc'.
- Use a different file format to save the item from SuperTABLE. CSV is a common replacement for spreadsheets. (File -> SaveAs -> Comma-Separated Table CSV). Excel will open the CSV file but things such as fonts, styles and colors will not be transferred automatically.
- The other SuperTABLE format which might preserve the table appearance is HTML. (File -> SaveAs -> HTML - Single File). Excel will open the HTML format also.
This behaviour results from Microsoft altering the XLS file format as part of Office 2003 Service Pack 3. Microsoft have published a Knowledge base article (938810) which describes registry edits to work around the problem.
Clients with earlier versions of Excel should not notice the issue when using XLS files created by SuperCROSS. |
