Ask Your Question

Pivot Table selection restrictions

asked 2016-12-05 18:23:18 +0200

shine gravatar image

I've been trying to create a pivot table with 70,000+ rows and 165 columns. But I am able to create to a maximum of 11212 rows with 165 columns (1849980 cells). Both these combinations don't look right to me.

Does LibreOffice have any restrictions on Pivot Table selection? Or am I doing something wrong?

Configuration : LibreOffice 10m0(Build:2) (The default (and latest) one that comes bundled with Ubuntu) Ubuntu 16.04.1 LTS

edit retag flag offensive close merge delete


70000x165 it's the source data or the pivot table itself?

m.a.riosv gravatar imagem.a.riosv ( 2016-12-05 23:15:48 +0200 )edit

I guess you haven't really understood my question @m.a.riosv

70,000+ x 165 is the source data. My problem is that I can't create a pivot table with that range. The maximum source data range I can use to create the pivot table is 11212 x 165.

shine gravatar imageshine ( 2016-12-09 08:36:06 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-12-05 23:11:05 +0200

Ratslinger gravatar image

Never having to use one that large, ran test on Mint 18 using LO v5.2.3.3. I set a small selection initially & stated to use "Selected Area". When the dialog come up, I modified the selection to go from col "A" to col "AMJ" (max) for 500,000+ rows (I know more are available). There isn't any visible indicator (except the selection entered didn't change - ie: $AMJ which was entered) but this selection change takes time. I observed this watching one of the cores on the CPU process @ 100% for about eight minutes (machine is about 6yr old). When the selection process completed, the selection changes entered appeared ($AMJ etc.) and core processing went to zero. Point is, it should work.

edit flag offensive delete link more


I don't know if something was changed between and, but what I get is Error creating the pivot table

shine gravatar imageshine ( 2016-12-09 08:44:41 +0200 )edit

Using LO v5.1.4.2 on Xubuntu I ran the same selection as in the answer without any error. The only difference, I used the version from LibreOffice and not from Ubuntu.

Ratslinger gravatar imageRatslinger ( 2016-12-09 18:23:00 +0200 )edit

answered 2016-12-09 23:22:33 +0200

m.a.riosv gravatar image

Works for me with 170 columns x 70000 rows, on 5.1.6.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-12-05 18:23:18 +0200

Seen: 240 times

Last updated: Dec 09 '16