Problem Note 51869: Incorrect data occurs in Excel columns if you export more than 675 columns when using the XLSX engine
 |  |  |  |  |
Unreadable content errors and incorrect data might occur when you open an Excel .xlsx file that was created by the XLSX driver.
The problem occurs when you export more than 675 columns to an Excel worksheet in an Excel workbook. When you open the file in Excel 2013, you see the following message:
If you click Yes, you then see this message:
In Excel 2010, you see a message similar to this:
When you open the Excel file, data might not be in the correct columns.
The problem occurs because of a bug in the XLSX engine. The bug occurs in the engine itself when you export .xlsx files that contain more than 675 columns.
To circumvent the problem, export your data to a tab-delimited text file if the data contains more than 675 columns. A comma-delimited file works if your data does not contain commas.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Windows 7 Ultimate x64 | 9.3 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 9.3 | 9.3 TS1M0 | ||||
| Windows 7 Home Premium x64 | 9.3 | 9.3 TS1M0 | ||||
| Windows 7 Enterprise x64 | 9.3 | 9.3 TS1M0 | ||||
| Microsoft Windows Server 2008 for x64 | 9.3 | 9.3 TS1M0 | ||||
| Microsoft Windows Server 2003 for x64 | 9.3 | 9.3 TS1M0 | ||||
| Microsoft® Windows® for x64 | 9.3 | 9.3 TS1M0 | ||||
| Windows Vista for x64 | 9.3 | 9.3 TS1M0 | ||||
| 64-bit Enabled AIX | 9.3 | 9.3 TS1M0 | ||||
| 64-bit Enabled HP-UX | 9.3 | 9.3 TS1M0 | ||||
| 64-bit Enabled Solaris | 9.3 | 9.3 TS1M0 | ||||
| HP-UX IPF | 9.3 | 9.3 TS1M0 | ||||
| Linux | 9.3 | 9.3 TS1M0 | ||||
| Linux for x64 | 9.3 | 9.3 TS1M0 | ||||
| Solaris for x64 | 9.3 | 9.3 TS1M0 | ||||
A fix for this issue for SAS/ACCESS Interface to PC Files 9.4_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R22.html#51869A fix for this issue for SAS/ACCESS Interface to PC Files 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J37.html#51869| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2014-01-14 10:16:44 |
| Date Created: | 2013-12-18 14:25:44 |