Excel Table Is Slow

[wsnyder]

Hi all,

Using Excel Microsoft 365.

I have an Excel Table.
I deleted all data from the Table and then resized the table to $A$1:$A$2
I then added 13k rows of data beginning at Row 2.
That is where the slowness began.
Why does it take so long for Excel to resize the table to include all 13K rows?
What do you do to defeat this behavior?

Thanks,
-w

 

[Marc L]

Hi,​

​

as Excel is not well known for its speed, at least 50 times slower than any database software, often more than 100 X …​

 

[Joe4]

I haven't tested this out myself, but is it faster to NOT have a table to start, and add your data first, then create the table using the data?