+ Reply to Thread
Results 1 to 5 of 5

Why my Excel file is so slow?

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    London
    MS-Off Ver
    Excel 2003 Excel 2010
    Posts
    189

    Why my Excel file is so slow?

    Hi,

    I have an Excel file. It is really slow, even if I cut/paste to move some static text. Is it because some functions are automatically refreshed when the file has some changes?

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Why my Excel file is so slow?

    Is there conditional formatting? Select the entire sheet with the conditional formatting and look at rules. If you copy/paste a lot, it will make a new conditional formatting rule every time. Eventually, every copy paste makes hundreds of new rules, and everything gets really slow.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    London
    MS-Off Ver
    Excel 2003 Excel 2010
    Posts
    189

    Re: Why my Excel file is so slow?

    Not a lot of copy/paste. Even if I just copy/paste a single word, still very slow.

  4. #4
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Why my Excel file is so slow?

    I mean that Copy/Paste can create the problem that causes things to run slowly. Did you look at the Conditional Format rules to check?

  5. #5
    Forum Contributor
    Join Date
    01-16-2014
    Location
    London
    MS-Off Ver
    Excel 2003 Excel 2010
    Posts
    189

    Re: Why my Excel file is so slow?

    Conditional formatting does exist a lot in the file. But the static text that I cut/paste has no conditional formatting.

+ 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. Big excel file with vba, slow processing
    By lukeckh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2013, 08:19 PM
  2. Excel file is slow
    By Shradharani in forum Excel General
    Replies: 3
    Last Post: 07-18-2013, 07:47 AM
  3. Replies: 3
    Last Post: 12-14-2011, 04:58 PM
  4. HELP! Extremely slow excel file
    By floripabay in forum Excel General
    Replies: 1
    Last Post: 06-29-2011, 06:07 AM
  5. excel file slow
    By sanlen in forum Excel General
    Replies: 1
    Last Post: 07-20-2010, 06:30 AM

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