What's the best way to insert large data into a table.
When I insert more than a few item into a table, the file freezes/locks up. The table has 1500 rows with two col with formulae and one with some conditional formatting. To insert the new rows of data, I have to first convert the table to a range.. insert the new data and covert back to a table. Macros for a userform refer to the original table #, so I've been changing the name in Name Manager everytime I add new data/rows.
When I insert more than a few item into a table, the file freezes/locks up. The table has 1500 rows with two col with formulae and one with some conditional formatting. To insert the new rows of data, I have to first convert the table to a range.. insert the new data and covert back to a table. Macros for a userform refer to the original table #, so I've been changing the name in Name Manager everytime I add new data/rows.
