I am using Excel 2010.
My data source has blank cells.
The Pivot Table displays (blank) for those cells.
I have tried right clicking on a cell in the Pivot Table, selecting Pivot Table Options, Layout & Format, toggling on "For empty cells show:" and put in n/a. Nothing changes on the Pivot Table. I have refreshed the table
What is the correct procedure to eliminate the "(blank)"s in the Pivot Table or replace them with "n/a"
Thank you.
My data source has blank cells.
The Pivot Table displays (blank) for those cells.
I have tried right clicking on a cell in the Pivot Table, selecting Pivot Table Options, Layout & Format, toggling on "For empty cells show:" and put in n/a. Nothing changes on the Pivot Table. I have refreshed the table
What is the correct procedure to eliminate the "(blank)"s in the Pivot Table or replace them with "n/a"
Thank you.