Originally Posted by
Daxton A.
notice that it only took a while when I opened up the third page: "C". But it happens on a lot more sheets than the one that I have in that workbook. But again, I am trying to figure out why that happens?
Does it happen on your PC's?
Hi Daxton,
Yes, page C (and another) took longer than the others to open. I also noticed the file size was 1.36MB when I opened it, which seems way too large for the actual contents.
Using this code on the active sheet reduced it to 283kB, if there is nothing below row 83 on the original, run it on the original (all sheets) and see if that's any better:
Sub CleanUp()
Range("A83:IV65536").Delete
End Sub
Caveat: This will delete all the empty rows and Excel will automatically re-generate new rows to replace them, however, Excel only has the capacity to regenerate like this a limited number of times (I don't know exactly how many, but I found it's somewhere between 50 to 100 times or so) - after that it effectively "kills" the sheet...
HTH,
John