Excel extremely slow with data table?

[Fritz23]

I have a data table for range A1:G2000 as there are a series of formula cells where I want to keep the formula preserved when rows are inserted. This works great, but anytime I select more than 2 cells, even non-formula cells with just text, Excel slows to a crawl.

In addition, I have some VBA code (see this posting for more information: Data Validation List - Auto update cell values with a twist) to run calculations when necessary. Outside of that code, I have all my calculations set to manual.

I have found that if I convert the table to a standard range, I don't have performance issues, but then I lose out on maintaining the formula cells for inserted rows.

Any suggestions?

 

[Fritz23]

Correction to the above: "...anytime I select more than 2 cells and copy them, even non-formula cells with just text, Excel slows to a crawl.