+ Reply to Thread
Results 1 to 4 of 4

Excel file is slow

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    India.Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    97

    Excel file is slow

    Hi
    I am working on 2007 excel and I have one excel file which is creating problems now and then .

    1) File is very slow
    2) I am not able to delete any line items its shows error message as “ Excel cannot complete this task with available resources .Choose less data or close other application”.(I am trying to delete only one line )

    My file size is 539 KB .

    File contains some data for which formula are linked and file is saved in Binary format.

  2. #2
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: Excel file is slow

    Hi,

    Try this.

    Select and copy the full worksheet by clicking top left, near the cell A1 ( where row and column joins). Paste in new excel file. Save & open it. See if it is still slow.

    Even then if it's slow, then we need to check if any formulas causing the slowness.

  3. #3
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: Excel file is slow

    And Check for too much conditional formating also...
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

  4. #4
    Registered User
    Join Date
    08-03-2012
    Location
    India.Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    97

    Re: Excel file is slow

    I have tried all these ... I cannot delete formulas these are essencial ... But the file size is less but still it gives this error

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 12-14-2011, 04:58 PM
  2. HELP! Extremely slow excel file
    By floripabay in forum Excel General
    Replies: 1
    Last Post: 06-29-2011, 06:07 AM
  3. excel file slow
    By sanlen in forum Excel General
    Replies: 1
    Last Post: 07-20-2010, 06:30 AM
  4. Slow in opening excel file
    By celestar in forum Excel General
    Replies: 1
    Last Post: 07-12-2006, 08:15 AM
  5. [SOLVED] Excel slow to close file/program
    By Ken in forum Excel General
    Replies: 2
    Last Post: 04-23-2005, 12:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1