Hi there!
I am having the problem with my tables in Excel (some, but not all, containing some formulas, like vlookups, also to another workbook). Tables are of different sizes, some just few hundreds rows and few columns, largest has few thousands rows and 30 columns.
When resizing the table, for example adding column or deleting the row, it takes enormous time, sometimes over 30 minutes. My PC is quite fast, also tried on different machines, some older would just crash.
What might be the reason and how to avoid this?
I am having the problem with my tables in Excel (some, but not all, containing some formulas, like vlookups, also to another workbook). Tables are of different sizes, some just few hundreds rows and few columns, largest has few thousands rows and 30 columns.
When resizing the table, for example adding column or deleting the row, it takes enormous time, sometimes over 30 minutes. My PC is quite fast, also tried on different machines, some older would just crash.
What might be the reason and how to avoid this?