Excel unresponsive after formating array as table

%3CLINGO-SUB%20id%3D%22lingo-sub-1509824%22%20slang%3D%22en-US%22%3EExcel%20unresponsive%20after%20formating%20array%20as%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509824%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CP%3EExcel%20for%20MS%20365%20(16.0.13001.20266)%2032-bit%3C%2FP%3E%3CP%3EStarting%20with%20a%20file%20with%20one%20sheet%2C%20data%20in%20contiguous%20array%20(15%20columns%2C%2010000%20rows%2C%20but%20these%20numbers%20are%20not%20critical%20for%20the%20issue)%2C%20no%20formulas%20or%20external%20connections.%3CBR%20%2F%3EWhen%20the%20array%20is%20formatted%20as%20a%20table%2C%20scrolling%20through%20the%20data%20(with%20scroll%20wheel%20on%20mouse%20or%20with%20scroll%20bar)%20becomes%20very%20slow%20(taking%20between%201%20and%2010%20seconds%20for%20the%20app%20to%20become%20responsive%20again).%20The%20CPU%20utilization%20rises%20sharply%20from%20less%20than%201%25%20to%20more%20than%2030%25%20during%20this%20period.%3CBR%20%2F%3EConverting%20the%20table%20back%20to%20an%20array%20restores%20normal%20responsiveness.%20These%20steps%20can%20be%20repeated%20with%20same%20results%3A%20formatted%20table%3A%20very%20slow%2C%20array%3A%20snappy.%3CBR%20%2F%3EThis%20behavior%20started%20a%20few%20weeks%20ago%2C%20presumably%20in%20version%2016.0.12827.%3C%2FP%3E%3CP%3ETried%20safe%20startup%2C%20disable%20all%20add-ins%2C%20fix%20Office%20installation%3B%20no%20influence%20on%20behavior.%3C%2FP%3E%3CP%3EWhat%20could%20be%20the%20cause%3F%3C%2FP%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1509824%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Excel for MS 365 (16.0.13001.20266) 32-bit

Starting with a file with one sheet, data in contiguous array (15 columns, 10000 rows, but these numbers are not critical for the issue), no formulas or external connections.
When the array is formatted as a table, scrolling through the data (with scroll wheel on mouse or with scroll bar) becomes very slow (taking between 1 and 10 seconds for the app to become responsive again). The CPU utilization rises sharply from less than 1% to more than 30% during this period.
Converting the table back to an array restores normal responsiveness. These steps can be repeated with same results: formatted table: very slow, array: snappy.
This behavior started a few weeks ago, presumably in version 16.0.12827.

Tried safe startup, disable all add-ins, fix Office installation; no influence on behavior.

What could be the cause?

 
 
0 Replies