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