IBM Support

How to set Sheet names when saving to Excel .xlsx format.

Question & Answer


Question

In previous versions IBM SPSS Statistics 19 and 20 when saving to Excel .xlsx format the sheet names defaulted to Sheet 1, Sheet 2, and Sheet 3. In version Statistics 21 the sheet name is now generated based on the file name.

[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Statistics Desktop","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"21.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM SPSS Statistics

Software version:
21.0

Document number:
477733

Modified date:
16 June 2018

UID

swg21610825

Manage My Notification Subscriptions