PDA

View Full Version : Error: Excel cannot complete task with available resources???



infinity
09-23-2009, 04:58 PM
HELLLLP! :help

I am trying to add rows at the top of a worksheet through code and everytime, I get the error "Excel cannot complete this task with the available resources, choose less data or close other applications". I am doing this on a sheet that has no formulas or formatting only raw text data and it only had about 30 lines of data on it. I then tryed it on the same worksheet with no data on it and I still get the same error. I tried doing it without using my code and get the same thing! This is driving me insane!!! Please if anyone has a solution, I would be most appreciative. Thank you all so much. :banghead:

mdmackillop
09-23-2009, 05:13 PM
What version are you using?

infinity
09-23-2009, 05:36 PM
What version are you using?

Office 2007

mdmackillop
09-24-2009, 01:20 AM
I guessed that.
My "solution" to a similar problem: Always save as Excel2003 workbook, unless you reaaly need the full sheet size, and then you are stuck!

rbrhodes
09-24-2009, 01:21 AM
Post a small example of the data (or the sheet) so we can try to replicate?