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

R

RichHoughton

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
 
T

tylagusim

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 /
 
Top