I am working with 273 column X 16394 row excel sheet. I did something really stupid and i put the MAX() function in 26 of the columns. It only took me about 5-10 minutes to paste these functions into excel, but for some reason its going to take ~15 hours to delete it.
I successfully deleted one of the 26 columns and it took 36 minutes. I did some experimenting and I found that the first and last 1000 cells in a column only take 20 seconds to delete. But the 1000 cells in the middle of the column take 3 minutes to delete.
The file is 27 Mb so i can only upload a small portion. I highlighted the columns causing my grief.
Is there a simple way to get excel to use all 4 of my cores to delete these cells? I am a little bit of a newbie to vba so hopefully its not going to take more than 14 hours of effort to learn this.
And yes my excel is set to manual calculation.
Any suggestions or help is appreciated
-Daniel
Bookmarks