I have a large table on one sheet in an excel workbook. Whenever I run a pivot table off of this table, it picks up the whole table except the top 50 or so rows. If I alter my pivot table source data to capture the whole table excluding the last row (i.e. the cells themselves, rather than the table as a collective, it works fine).
Any suggestions?
Bookmarks