MXCELLS and WORKSPACE Subcommands(SET command)

WORKSPACE allocates more memory for some procedures when you receive a message indicating that the available memory has been used up or indicating that only a given number of variables can be processed. MXCELLS increases the maximum number of cells you can create for a new pivot table when you receive a warning that a pivot table cannot be created because it exceeds the maximum number of cells that are allowed.

• WORKSPACE allocates workspace memory in kilobytes for some procedures that allocate only one block of memory. The default and minimum value is 24576.
• Do not increase the workspace memory allocation unless the program issues a message that there is not enough memory to complete a procedure.
• Use MXCELLS with caution. Set MXCELLS at a number higher than the limit indicated in the warning message that you receive. After the table is created, restore the number to the default.
• The memory-allocation or cell maximum number increase takes effect as soon as you run the SET command.

Note: The MXMEMORY subcommand is no longer supported.