Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I made a template for running some statistical data through. It ran slow
every time I tried saving and it wasn't until I tried e-mailing it that I realized it was 75MB. It has 14 spreadsheets and all my data is contained with in the first 20 columns and first 50 rows. the problem is that the rows go down to ~65,000 and I can't seem to get rid of them. Selecting them alone using ctl+shft+down makes the program not respond for a few minutes and when I right click and select delete the program freezes altogether. I have tried selecting smaller portions of the spreadsheets and it still doesn't seem to lower the total amount of rows. The spreadsheets were originally made in 2002 and now in 2007[Compatibility Mode]. Any help would be much appreciated - especially considering I have people waiting for this data, but cannot send it out. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
delete cells column. Delete empty cells | Excel Worksheet Functions | |||
How do I delete rows where cells are empty | Excel Discussion (Misc queries) | |||
delete all empty cells in a range | Excel Worksheet Functions | |||
Delete Empty Cells in a Macro | Excel Discussion (Misc queries) | |||
delete rows with empty cells | Excel Discussion (Misc queries) |