Pivot table missing a lot data

Hi everyone!

I created a pivot table (attached) out of the data that you helped me chunk into less details (turning every 125 rows into a single row, to be precise), but the pivot table is missing a lot data...starting from "Recording 40" rows, there is no data. This might stem from the partial data I provided the ones that solved my former issues (about 3,500 rows out of 130,765 rows) due to the file size limit I ran into in the forum. I tried to fix it up changing the formulas to up to row 130,765, but I'm afraid it hasn't been resolved and that this is what caused the missing data in my pivot chart.

Sadly, I ran into the same problem in this post too, so I had to shorten my file again to 3,500 rows.

Can you nonetheless help me fill in the missing data in my pivot chart?

Thanks a lot in advance!
Rakefet

Click anywhere in your pivot table and then Analyze -> Change Data Source.

Make sure that your entire dataset is included as your data source.

Then refresh the pivot table.

Thanks a lot for your response!
My pivot table is still missing a lot of data though.
My full spreadsheet is here.
Could you or someone else please help me out?

Thanks a lot! <3
It seems like the problem was solved but I just have to make sure before I mark this thread as solved.