Hi, well a bit of an update. I ctl+shift+end and the cell range was off the charts. I tried to download a tool to remove it however the sheet kept freezing. Any suggestions?

I did try to do a cut down version of the sheet but couldn't get it below a meg even with just three rows of data. I assume this has something to do with the last cell issue. Thanks.