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

Ask Your Question

How to specify an endless range for a pivot table source in Calc? [closed]

asked 2016-12-19 19:15:42 +0200

tyebillion gravatar image

updated 2016-12-19 19:22:08 +0200

I can create a pivot table with an explicit range for the source no problem:


But when I try to create a pivot table with an endless range for the source e.g. all rows after the header, the source text goes white and the pivot table is not correct:


How can I specify an endless range for the source without including blank rows?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-16 18:50:16.820245

1 Answer

Sort by » oldest newest most voted

answered 2016-12-19 22:48:26 +0200

m.a.riosv gravatar image

Introducing $Income.$A:$D transforms the reference on the source range to $Income.$A$1:$D$1048576 maximum range for rows, seems that pivot table doesn't keep columns address, in any case marking the option to ignore empty rows, seems that help a bit with the speed.

edit flag offensive delete link more


I'm guessing that you are not recommending this method?

tyebillion gravatar imagetyebillion ( 2017-02-13 20:37:49 +0200 )edit

Question Tools

1 follower


Asked: 2016-12-19 19:15:42 +0200

Seen: 77 times

Last updated: Dec 19 '16