Why are the rows and columns of my pivot table showing blank when there is data?

Answer 1

Ensure your data source highlights the correct table by selecting Change Data Source. This will ensure you have the correct range of cells being pulled into the pivot table. If that is good try removing all fields from rows, columns, filters and values then put them back in. Being able to see your pivot and dataset would be helpful.

Answer 2

This question is too general. Make sure your pivot is properly set up, then refresh... especially the "Values" area