| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table with more than 3 columns | Excel Worksheet Functions | |||
| Display the source for a pivot table page field | Excel Worksheet Functions | |||
| Grouping data in pivot table columns | Excel Discussion (Misc queries) | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| combining 3 columns of same info for a pivot table | Excel Worksheet Functions | |||
Linear Mode
