Pivot table *blanks*

buffalo

Board Regular
Joined
Jun 19, 2003
Messages
183
Because I constantly update data in Columns A thru D, I included
Sheet1!$A:$C in the Range field of mt pivot table.

Every thing updates when I refresh the pivot table now.

EXCEPT -- I have in the row and the column I have this entry called a blank
Code:
Count of Score	State					
Name	MA	NY	WA	(blank)	Grand Total	
Jeff		
Jim		
John		
Joy	
(blank)						
Grand Total

(The row 1 entry for each column in the original data sheet is a name..
So in this example... Name , State, Score)

I want to remove this (blank) entry from both places..
Any suggestions?
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Hi Buffalo,

Sounds like you're still working on the same pivot table you referenced in your other post. I know of no way to automatically get Excel to ignore the blanks if you set the entire column as the source. Again, in the other post I mentioned previously there are suggestions on how to create a dynamically resizing data range which would solve your problem.

Otherwise, if you're using XL2002, you can simply click on the dropdown list, scroll down to the checkbox for (blanks) and uncheck it.

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,113,800
Messages
5,544,347
Members
410,605
Latest member
hinspate
Top