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
(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?
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?