View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sandi Sandi is offline
external usenet poster
 
Posts: 42
Default Pivot Table with Blank Rows - HELP

I have a spread sheet that has over 12000 rows. When I try to do my
PivotTable, I keep getting an error message. The reason I think I get the
message is that every other row in my worksheet is blank. Is that a problem
and if it is, is there a way that I can delete these rows without having to
do it one by one and selecting them all, there are over 12000 rows so it
would be very time consuming. Any help would be appreicated.
--
Sandi Gardner