Hi,
I have an excel file that is currently 27,421KB.
It was previously 33,000KB but I have taken out 15 tabs sheets and packaged this up as a separate file.
I still think I can bring it down further by clearing it up and one thing I am doing is stepping through each tab sheet and pressing ctrl + end.
And I noticed that a lot of them are taking me way far too down than where my last data actually is.
I am trying to clear these blank excess rows by deleting them but I get a warning message saying this operation affects a large number of cells > I click ok and then I get an Excel error message Excel ran out of resources.
I do not have any other applications running when I am doing this.
Is there anyone out there that has dealt with this kind of issue successfully?
Thank You
Bookmarks