Hi all,
Recently I have been running macros with large data sets, transform the data, do some calulcations, output the data.
In excel 2010 this is no problem, my codes run fast .
When in excel 2013 I get a white screen at times, excel not responding, I cant have other excel sheets open, and overall takes alot of time to run the same codes.
I ask because I want someone to use my codes, but in excel 2013 they cannot run smoothly, i myself have tested in 2013 and get same results, slow, hours to load.
Why is this? Is there anyway around this? Any suggestions I could add to my code to help? My excel files could be around 30,000-40,000 kb.
Recently I have been running macros with large data sets, transform the data, do some calulcations, output the data.
In excel 2010 this is no problem, my codes run fast .
When in excel 2013 I get a white screen at times, excel not responding, I cant have other excel sheets open, and overall takes alot of time to run the same codes.
I ask because I want someone to use my codes, but in excel 2013 they cannot run smoothly, i myself have tested in 2013 and get same results, slow, hours to load.
Why is this? Is there anyway around this? Any suggestions I could add to my code to help? My excel files could be around 30,000-40,000 kb.