Ask Your Question
0

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

asked 2013-09-21 20:43:05 +0200

deckoff gravatar image

updated 2013-09-21 20:44:21 +0200

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`
edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-09 09:33:00.270161

1 Answer

Sort by » oldest newest most voted
0

answered 2013-09-21 21:35:02 +0200

w_whalley gravatar image

updated 2013-09-21 21:51:31 +0200

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.

edit flag offensive delete link more

Comments

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?

deckoff gravatar imagedeckoff ( 2013-09-21 23:18:20 +0200 )edit

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.

w_whalley gravatar imagew_whalley ( 2013-09-22 14:47:15 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-09-21 20:43:05 +0200

Seen: 2,023 times

Last updated: Sep 21 '13