Too much data in PowerQuery can cause Excel to freeze

Wolfe M 0 Reputation points
2024-10-28T12:54:18.56+00:00

Import data from an Excel workbook through Power Query, but the data is quite large, with approximately 3000+rows. Importing is normal, but when loaded into Excel, it can cause Excel to freeze.

I have created a simple example and this issue will not occur.

There are no other large files to test whether it only occurs in Excel.

Try opening files containing big data Workbook directly without any issues.

Do you have any suggestions that can help solve this problem?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,724 questions
0 comments No comments
{count} votes

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.