+ Reply to Thread
Results 1 to 9 of 9

Deleting rows is causing error message

  1. 03-12-2014, 01:36 PM #1
    FRANKinATLANTA
    FRANKinATLANTA is offline
    Registered User
    Join Date
    03-12-2014
    Location
    ATLANTA GA USA
    MS-Off Ver
    Excel 2013
    Posts
    35

    Deleting rows is causing error message

    Hello all.

    A large Excel file that I have been working with for months is now giving me trouble.

    When I tried to delete 2 rows, it displayed a message: "Excel cannot complete this task with avail resources. Choose less data or close other applications."

    I opened a previously saved version of the file and tried deleting rows, and the same message came up.

    I shut down the computer, rebooted, same problem.

    Any suggestions please??! Also, is there a way to determine if a file has been corrupted .... or even worse ... is there a possibility that my Excel program itself is corrupted?


    I appreciate any guidance on this. Thank you!!
    Last edited by FRANKinATLANTA; 03-12-2014 at 02:50 PM.
    Reply With QuoteRegister To Reply
  2. 03-12-2014, 02:04 PM #2
    aworfolk
    aworfolk is offline
    Forum Contributor
    Join Date
    12-10-2013
    Location
    Mississippi, United States
    MS-Off Ver
    2016
    Posts
    120

    Re: How do I troubleshoot an Excel file?

    The issue is you have to many columns for it to delete it all at once look at your scroll bar at the bottom it is probaly very tiny see if there are and excess coloumns at the end of your worksheet that can be delted then try again.
    Reply With QuoteRegister To Reply
  3. 03-12-2014, 02:37 PM #3
    FRANKinATLANTA
    FRANKinATLANTA is offline
    Registered User
    Join Date
    03-12-2014
    Location
    ATLANTA GA USA
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: How do I troubleshoot an Excel file?

    I'm not following your thought ....

    My last column with data is column MZ. The worksheet has 10,500 rows. The file has approx 15 worksheets this size.

    If i scroll out to the right I see "infinite" columns. Is there a way to delete any columns past MZ??

    This problem just occurred today and is now reoccurring. It never happened before. My file is the same size now as it was before.

    I'm really needing help with this ... I'm dead in the water moving forward!!! Thank you!!
    Reply With QuoteRegister To Reply
  4. 03-12-2014, 02:37 PM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,744

    Re: How do I troubleshoot an Excel file?

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  5. 03-12-2014, 03:01 PM #5
    FRANKinATLANTA
    FRANKinATLANTA is offline
    Registered User
    Join Date
    03-12-2014
    Location
    ATLANTA GA USA
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Deleting rows is causing error message

    I should add that inserting new rows or performing "drag" function also produces this error. And the file locks up at this point.

    Thanks for any/all help!
    Reply With QuoteRegister To Reply
  6. 03-13-2014, 02:11 AM #6
    steve.smith
    steve.smith is offline
    Registered User
    Join Date
    04-09-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Deleting rows is causing error message

    When an Excel file shows 'Excel cannot complete this task with avail resources. Choose less data or close other applications.' error message , then you can try one of the following method to resolve it:
    1. Check whether you exceed limits
    2. Make sure only one instance of Excel is active
    3. Close all applications and try again
    4. Test Excel workbook file in safe mode
    5. Save as an Excel workbook file if you use relative names
    Reply With QuoteRegister To Reply
  7. 03-13-2014, 08:16 AM #7
    FRANKinATLANTA
    FRANKinATLANTA is offline
    Registered User
    Join Date
    03-12-2014
    Location
    ATLANTA GA USA
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: Deleting rows is causing error message

    Thank you Steve for the suggestions.

    #2 and #3 - both were the case and the problem persisted

    #1 - where (or how) is this check done??

    #4 - again, I would like to know how this is done (I've never seen Excel ask if I wanted to open a file in Safe Mode)

    #5 - file is saved as filename.xlsx .... is this what it should be saved as?

    Thank you for the help!
    Reply With QuoteRegister To Reply
  8. 03-13-2014, 11:00 AM #8
    aworfolk
    aworfolk is offline
    Forum Contributor
    Join Date
    12-10-2013
    Location
    Mississippi, United States
    MS-Off Ver
    2016
    Posts
    120

    Re: Deleting rows is causing error message

    To open Excel in safe mode Hold the Control key and open excel a message box will pop up and ask if you whant to open excel in safe mode.
    Reply With QuoteRegister To Reply
  9. 03-14-2014, 12:39 AM #9
    steve.smith
    steve.smith is offline
    Registered User
    Join Date
    04-09-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Deleting rows is causing error message

    Quote Originally Posted by FRANKinATLANTA View Post
    Thank you Steve for the suggestions.

    #2 and #3 - both were the case and the problem persisted

    #1 - where (or how) is this check done??

    #4 - again, I would like to know how this is done (I've never seen Excel ask if I wanted to open a file in Safe Mode)

    #5 - file is saved as filename.xlsx .... is this what it should be saved as?

    Thank you for the help!
    Hi FRANKinATLANTA,

    Read this KB article: http://support.microsoft.com/kb/2655178

    All the methods are explained in brief.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How do we troubleshoot a corrupt file?
    By Habanero Time in forum Excel General
    Replies: 0
    Last Post: 06-11-2012, 05:15 PM
  2. Excel 2007 : Excel spreadsheet troubleshoot formulas
    By c4rolo in forum Excel General
    Replies: 2
    Last Post: 01-23-2010, 02:35 PM
  3. Troubleshoot Excel-vba Code
    By dhavanchopra in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2007, 09:03 AM
  4. troubleshoot e-mail from Excel
    By tweetweetweedle in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-01-2005, 04:09 PM
  5. [SOLVED] Troubleshoot a bug in Excel
    By d_a_v_e_s@hotmail.com in forum Excel General
    Replies: 1
    Last Post: 10-16-2005, 10:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1