How to add a whole column to pivot table, not only a selection of it?

[deckoff]

I am trying to create a pivot table, and add rows to the source every few days. Unfortunately newly added data is not processed. I hit refresh, of course.
If I create a pivot table, and select only one column as a source, newly added data is calculated after refresh.
Source looks like this

$Sheet1.$D$1:$D$42

If the source contains a few columns, for example:

$Sheet1.$A$1:$G$42

Newly added entries are ignored, even after refresh. If I define range with completely empty rows, I get an error message i.e $43 gives an error.

With Kingsoft I can just specify

`=Sheet1!$A:$G`

[w_whalley]

My suggestion: Define a named range for your data and include extra empty rows (or just include extra empty rows in the selection). In the Pivot Table layout, use the named range as the Selection from entry. In the pivot table More section, check the Ignore Empty Rows box.

You will still have to manually update your pivot table (right-click on pivot table and click Refresh), but you won’t have to expand your pivot table source.

[deckoff]

OK, I found out how to define a name range, but when I > data >pivot table > create> in “select source” dialog the option “Named range” is grayed out. LO Version: Build ID: 410m0(Build:2) on Ubuntu 12,04. i can select the defined name range… any ideas?

[w_whalley]

Verify that you have actually defined a name range (View->Navigator/Range Names), or forget about range names and just construct the pivot table using a selection that includes blank rows.