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?
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,022
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
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,470
Messages
5,764,513
Members
425,221
Latest member
MercedesCLK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top