Excel processing data is slow

pu rechard 100 Reputation points
2024-09-16T14:15:10.27+00:00

Excel will display multiple threads processing simple data when filtering, and even in cases where the amount of data is not large, there may be a certain amount of time waiting.

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,595 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,839 questions
0 comments
Accepted answer
  1. Emi Zhang-MSFT 24,676 Reputation points Microsoft Vendor
    2024-09-17T02:42:19.8833333+00:00

    Hi,

    Did this problem appear in all Excel Workbooks or specific Workbook?

    What version of Excel did you use?

    What kind of data did you use?

    I suggest you refer to this support article and check if these methods will help you:

    https://video2.skills-academy.com/en-us/office/vba/excel/concepts/excel-performance/excel-improving-calculation-performance

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 24,676 Reputation points Microsoft Vendor
    2024-09-17T02:42:07.78+00:00

    Hi,

    Did this problem appear in all Excel Workbooks or specific Workbook?

    What version of Excel did you use?

    What kind of data did you use?

    I suggest you refer to this support article and check if these methods will help you:

    https://video2.skills-academy.com/en-us/office/vba/excel/concepts/excel-performance/excel-improving-calculation-performance

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.