Original Message:
Sent: 6/12/2025 3:43:00 AM
From: Andrei Ramani
Subject: RE: How to increase total number of pivot table cells using SET MXCELLS?
Similar problem. I'm using IBM SPSS 30.
I'm not technically wrong, for example - I have 2 column: FamilyID, PersonID.
Using frequency, I want to know how many FamilyID - to get how many family member in each FamilyID.
Original Message:
Sent: Mon December 04, 2023 02:31 PM
From: Jon Peck
Subject: How to increase total number of pivot table cells using SET MXCELLS?
I suspect that your specification is seriously wrong if you are generating that many cells. What would you do with a table containing millions of cells?
This situation is often due to treating a continuous variable as a factor.
--
Original Message:
Sent: 12/3/2023 3:02:00 PM
From: Jane T
Subject: How to increase total number of pivot table cells using SET MXCELLS?
Hello,
I'm new to using SPSS v29. When I try to run the linear mixed model on my data but a warning pops up: the software states "the pivot table across split files exceeds 2000000. This limit can be altered using the SET MXCELLS command"
However I am not sure how to do this and can't seem to find this in the user manual. Could someone help guide me with this please?
Thanks!
------------------------------
Jane Tweedy
------------------------------