pivot table generated from whole columns (eg B:K)
 

Hi

I have a data table with ~14K rows. All subsequent rows are blank. When i
created a pivot table i made the source "Data!$B:$K". Having performed a
simple check i notice that the figures the pivot are pulling out are wrong.
If, however i change the data source to be "Data!$B1:$K14000" the data in the
pivot is correct. Any ideas what can be causing this problem?

Many thanks
RH

pivot table generated from whole columns (eg B:K)
 

It's probably the syntax you're using. The "$B:$K" syntax points to
all the rows in those columns; the "$B1L$K1400" points to just the
first 14K rows.

/ Tyla /

On Feb 10, 1:55 pm, RichHoughton
wrote:
Hi

I have a data table with ~14K rows. All subsequent rows are blank. When i
created a pivot table i made the source "Data!$B:$K". Having performed a
simple check i notice that the figures the pivot are pulling out are wrong.
If, however i change the data source to be "Data!$B1:$K14000" the data in the
pivot is correct. Any ideas what can be causing this problem?

Many thanks
RH