| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| In a pivot table, can the avg of a column include rows w/o data? | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| How do I remove the (blank) from an excel pivot table? | Excel Discussion (Misc queries) | |||
| Using Pivot Table Function to Summarize | Excel Discussion (Misc queries) | |||
Threaded Mode
