Extremely slow scrolling/editing in a Table but not in plain CSV

%3CLINGO-SUB%20id%3D%22lingo-sub-2159868%22%20slang%3D%22en-US%22%3EExtremely%20slow%20scrolling%2Fediting%20in%20a%20Table%20but%20not%20in%20plain%20CSV%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2159868%22%20slang%3D%22en-US%22%3E%3CP%3EI%20open%20a%20CSV%20file%20of%2015%20columns%20and%20about%2070k%20rows%2C%20I%20scroll%20the%20file%20up%20and%20down%20and%20everything%20is%20fine.%20Then%20I%20convert%20the%20data%20to%20a%20Table%20(Ctrl%2BL)%2C%20and%20after%20this%20scrolling%20becomes%20extremely%20slow%20(page-down%20may%20take%20seconds%20of%20Excel%20being%20unresponsive).%20Editing%20becomes%20slow%20too.%3C%2FP%3E%3CP%3EThe%20same%20CSV%20file%20works%20fine%20when%20converted%20to%20a%20Table%20on%20another%20PC.%3C%2FP%3E%3CP%3EThe%20issue%20started%20a%20few%20days%20ago%2C%20and%20it%20is%20not%20present%20in%20Excel%20for%20web%2C%20only%20in%20desktop.%3C%2FP%3E%3CP%3ERebooting%20the%20machine%20didn't%20help.%20Turning%20off%20hardware%20acceleration%20in%20Excel%20settings%20didn't%20help.%26nbsp%3B%3C%2FP%3E%3CP%3EShrinking%20the%20Excel%20window%20makes%20scrolling%20faster%2C%20but%20not%20as%20fast%20as%20it%20used%20to%20be%20before%20the%20issue.%3C%2FP%3E%3CP%3EAnyone%20faced%20this%3F%20Any%20help%20would%20be%20really%20appreciated.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2159868%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I open a CSV file of 15 columns and about 70k rows, I scroll the file up and down and everything is fine. Then I convert the data to a Table (Ctrl+L), and after this scrolling becomes extremely slow (page-down may take seconds of Excel being unresponsive). Editing becomes slow too.

The same CSV file works fine when converted to a Table on another PC.

The issue started a few days ago, and it is not present in Excel for web, only in desktop.

Rebooting the machine didn't help. Turning off hardware acceleration in Excel settings didn't help. 

Shrinking the Excel window makes scrolling faster, but not as fast as it used to be before the issue.

Anyone faced this? Any help would be really appreciated. Thanks!

1 Reply

@Vyacheslav145 I think you meant Control+T as the shortcut to create a table. 

i found this issue happen commonly with 32 bit versions of Office and can cause crashing due to some sheets being memory hogs. Do you need all that data? You can trim the data query and get what you need and get rid of the rest? You can also utilize Power Query to transform the data to get only what you need. 

https://docs.microsoft.com/en-us/office/troubleshoot/excel/clean-workbook-less-memory