why is a blank cell returned in pivot table when data exists?

Tags:
Microsoft Excel
PivotTable
I have a pivot table with one cell that appears blank. when I double click on the total for that row, the field is not blank. Why is the data not displaying in the pivot table? Show all is selected in that field header.

Answer Wiki

Thanks. We'll let you know when a new response is added.

First you need to identify if it an issue with the data or, the pivot table itself. If you double click the empty field, does a new worksheet open showing data that corresponds to that cell?
If you select different fields for the rows or columns in your pivot table, does you empty field “move” or does it stay in the same place? If it stays in the same place, obviously its the format/properties of the cell in excel preventing data from being shown.
If it “moves” then you have an issue with the data itself, so check your data source for any oddities.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jaideep Khanduja
    check the properties of that cell.
    9,040 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following