I have an unremarkable pivot table in a completely new workbook. I tried both "For empty cells show 0" in pivot table options and "show blank values" in field settings to no avail. Is there another method to force Excel to show items with value 0?

For example, this tutorial doesn't work for me at all.

  • What is it showing now? What kind of data is being summarized and how? – Excellll Jan 14 '15 at 19:37
  • @Excellll Numerical data on the left and the counts of those numbers on the right. – Max Power Jan 14 '15 at 19:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.