Results 1 to 8 of 8

Thread: Excel very slow problem

  1. #1

    Excel very slow problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi guys

    i need help, any solution for if excel is very slow due to too many of formula and data?

  2. #2
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    679
    Articles
    0
    Erm ... ???

    How about attaching the file that's running slowly?
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Quote Originally Posted by AliGW View Post
    Erm ... ???

    How about attaching the file that's running slowly?
    like this pic.


    because i got 10000 person, once i click the box, it will be loading for quite sometime. box got formula

    Click image for larger version. 

Name:	slow..png 
Views:	16 
Size:	18.9 KB 
ID:	7087

  4. #4
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    679
    Articles
    0
    An image is no use, especially as i can't see the formula in question!

    Are you using full arrays (e.g. A:A) or limited ones (e.g. A1:A1000)? If the former, change to the latter.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Quote Originally Posted by AliGW View Post
    An image is no use, especially as i can't see the formula in question!

    Are you using full arrays (e.g. A:A) or limited ones (e.g. A1:A1000)? If the former, change to the latter.
    I'm using A1:A10000
    and the formula is using you give me that one
    =SUMPRODUCT(sheet2!
    $B$2:$D$3000,($B$1:$D$1>=C2)*($B$1:$D$1<=D2)*(sheet2$A$2:$A$9=B5)
    )

  6. #6
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    679
    Articles
    0
    Right, OK, well we are going to need to see the workbook.
    Ali
    Enthusiastic self-taught user of MS Excel!

  7. #7
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    679
    Articles
    0
    The OP has informed me that he is unable to provide a workbook small enough to attach here that shows the problem. I have to assume, therefore, that the workbook in question contains a lot of large array formulae, probably using volatiles like INDIRECT, which are slowing the calculations down. I am unable to help further in the absence of the workbook.
    Ali
    Enthusiastic self-taught user of MS Excel!

  8. #8
    Have you tried splitting the data into specific sheets? That's what I do.

Posting Permissions

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