Excel Spreadsheet running slow
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Excel Spreadsheet running slow
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    New Member
    Join Date
    Jul 2019
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Spreadsheet running slow

    I defined it to A20000 for all the formulas and no difference of speed, and exported CSV to do the same things. I feel like I've tried everything, but it is slow to open, slow to add the data, and extremely slow when trying to filter out the data that I need.

  2. #12
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,678
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Excel Spreadsheet running slow

    maybe try PowerQuery (Get&Transform) instead of formulas
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #13
    New Member
    Join Date
    Jul 2019
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Spreadsheet running slow

    How would I go about doing that?

  4. #14
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,678
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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