Pivot Table Showing Blank Column Header

BlueRhinos

Board Regular
Joined
Aug 31, 2007
Messages
83
I have a pivot table a column header containing 3 values to indicate if someone has completed an assignment. Specifally, the values are (1) complete (2) in progress (3) not started. The row variable is a specific line of business groupsand provides completion counts. So, the table tells me that line of business A has 20 people, and 15 have completed the task, 3 are in progress, and 2 have not started. When i refresh the pivot table after updating the raw data, the table is returning a 4th value as a column header...namely Blank. there are no blank values in the raw data nor does the table have have any counts for that column. Any ideas why it's there and how I can fix?
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,025
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
I would guess your source data refers to more rows than currently have data in them.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,794
Messages
5,470,813
Members
406,726
Latest member
silverar

This Week's Hot Topics

Top