PM91591: "TOO MANY VARIABLES FOR EXCEL" ERROR WHEN TRYING TO EXPORT RESULTS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as Permanent restriction.

Error description

  • You have imported 302 prededfined categories to SPSS Text
    analytics for Surveys 4.0.1.  When you try to export your coded
    results to Excel file format, you get an error "Too many
    variables for Excel" and "Export cancelled".
    
    Even though the .xls file format is limited to 256 columns, the
    .xlsx format should accommodate these 302 fields.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of SPSS Text Analytics for Surveys                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You have imported 302 prededfined categories to SPSS Text    *
    * analytics for Surveys 4.0.1.  When you try to export your    *
    * coded                                                        *
    * results to Excel file format, you get an error "Too many     *
    * variables for Excel" and "Export cancelled".                 *
    *                                                              *
    * Even though the .xls file format is limited to 256 columns,  *
    * the                                                          *
    * .xlsx format should accommodate these 302 fields.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * No plans to fix                                              *
    ****************************************************************
    

Problem conclusion

  • No plans to fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM91591

  • Reported component name

    SPSS STAFS

  • Reported component ID

    5725A62TA

  • Reported release

    401

  • Status

    CLOSED PRS

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-21

  • Closed date

    2013-12-16

  • Last modified date

    2013-12-16

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels



Rate this page:

(0 users)Average rating

Document information


More support for:

SPSS Text Analytics for Surveys

Software version:

4.0.1

Reference #:

PM91591

Modified date:

2013-12-16

Translate my page

Machine Translation

Content navigation