Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Issues

Status
Not open for further replies.

drfads

Structural
Jul 14, 2006
12
I cannot delete rows in Excel 2007 which I am running on Windows 7(the RC Candidate). Every time I tried to delete a row (even a single row) this message pops: "Excel cannot complete this task with available resources. Choose less Data or close other applications"

Please advise.
 
Replies continue below

Recommended for you

I don't know squat about anything newer than excel 2003 and Windows XP.

However the error message you describe vaguely resembles the error message I get when I have data inadvertantly added to the last row/column of the spreadsheet and try to add a row. The solution is to delete the errant data, put the cursor into cell A1, and save.

That's a logical problem for adding, not so much for deleting... might be completely in left field.

Of course based on the error message, you might want to retry it with all other applications and spreadsheets closed.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.
 
Thanks for your replies- the issue is now occurring intermittently.
 
I think you are running out of memmory. You are running too many programs (or running in the background).

Never, but never question engineer's judgement
 
Nope- its not a memory issue. I have 4 GB to spare_ tried running application in solitude to cancel out any overload (too many processes)- that did not help either>>>
 
How bit is this particular worksheet?

Do you have any macros that get executed as a result of the row being deleted?

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
 
Also, sometimes if you have several tabs selected (sheet tabs) like when you want to copy or print several tabs (using ctrl key), it wont let you do things sometimes. Make sure that is not the case. I hope I am making sense.

Never, but never question engineer's judgement
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor