We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc Pivot Table giving me the error "Error creating the Pivot Table"

asked 2015-08-26 00:59:14 +0200

RyuSenshi gravatar image

I am trying to create a Pivot Table on Calc, but everytime I do so, it keeps giving me the error it experience the error creating the table. Anyone know the root of this problem?

edit retag flag offensive close merge delete


Hi, do you think that really it's possible an answer with a so breve information? :) Up voted your question to make possible for you attach a sample file with a table of data giving the error for you. Also please mention your LibreOffice version and your Operating System?

m.a.riosv gravatar imagem.a.riosv ( 2015-08-27 01:36:46 +0200 )edit

Version and operating system should have no bearing on this issue. Please, if you don't have any answer please don't answer and further risk annoying someone desperate enough to turn to a web forum to solve a problem.

Joe Desertrat gravatar imageJoe Desertrat ( 2015-10-04 20:41:29 +0200 )edit

What is your solution @joe?, I use pivot tables and never I have seen this issue, and I haven't seen bug reports with that problem.

m.a.riosv gravatar imagem.a.riosv ( 2015-10-07 01:41:26 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-06-29 01:52:03 +0200

I had the same error. It turned out to be because the number of unique items in the field I chose to be the column headings in the Pivot Table was more than the number of available columns. (It was a list of companies operating in each country).

Putting the companies as rows in the Pivot Table and the countries where they operated as columns solved the problem.

So I think this unspecific error is an error in literally creating the space for the table.

edit flag offensive delete link more


That is correct. The maximum number of columns is 1024. The pivoted data - every company - if it exceeds this number will raise this error.

Using LibreOffice (Version: Build ID: 1:6.4.5-0ubuntu0.20.04.1 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: kf5; Locale: en-ZA (en_ZA.UTF-8); UI-Language: en-ZA Calc: threaded)

So every company in every country would certainly exceed this number.

image description

openoneDave gravatar imageopenoneDave ( 2020-09-21 14:46:38 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-08-26 00:59:14 +0200

Seen: 631 times

Last updated: Jun 29 '20