Excel Table - Hard do deal with when more then 16,000 lines

[zapppsr]

I use Excel tables, to storage my data set. Especially because of dinamic range, to prevent new data, when inserted, to become out of the name interval.

In small amout of data, it works fine, but when I get some exported file, with about 16,000 lines, and I convert it to table, it gets really slow.

Now I put calculate on Manual in order to be able to use the worksheet.

Any hints on how to use tables for large amount of data? Removing backgrounds and grid lines are basic... what else?

 

[Excelestial]

COUNTIF functions slow down calculation considerably. Care to share what the functions are you're using in your spreadsheet for this large dataset?

Thanks.

 

[zapppsr]

SUMPRODUCT
IF
ISNUMBER
FIND

But only a single dataset, with 16,000 lines, with no calcultions, was taking ages do change a number format.

 

[Excelestial]

SUMPRODUCT will slow you.

 

[Excelestial]

Create a help column to concatenate selected columns to make your records unique. Perform calculations on this help column.

 

[zapppsr]

OK, will re-think my sumproducts.

Tks