I'm experiencing weird behavior with a pivot table. My file contains a Summary worksheet and 4 other worksheets. Each of the other tabs contains one table, named, with 5 columns of data. The summary sheet should take the text from the first column and the number from the second column of each worksheet and put them in one long list. This is essentially a way to show all the individual items consolidated. There are no calculations involved.
No matter what I do, the resulting list is limited to 25 rows and only 3 worksheets are ever read or appear in the Filter criteria of the pivot table, however all of the tables are referenced and functional in the pivot table.
I am unable to explain why the limit of 25 rows happens, or why all 4 sheets aren't read/included. If I delete any one sheet, the other 3 will report their lists, to a maximum of 25 rows. Baffling!!
Anyone have any insight on this? Many thanks in advance, I've been struggling for a couple days thinking this was something I'd done.
No matter what I do, the resulting list is limited to 25 rows and only 3 worksheets are ever read or appear in the Filter criteria of the pivot table, however all of the tables are referenced and functional in the pivot table.
I am unable to explain why the limit of 25 rows happens, or why all 4 sheets aren't read/included. If I delete any one sheet, the other 3 will report their lists, to a maximum of 25 rows. Baffling!!
Anyone have any insight on this? Many thanks in advance, I've been struggling for a couple days thinking this was something I'd done.
