Working with large data set and excel is “calculating threads” when I sort. What can I do to avoid this?
2
Director 1
Under formulas, there is calculation option. There is a drop down to turn your calcs to manual. Maybe that will stop the threads
2
Analyst 1
Alt m x m
1
Analyst 2
Alt f+t to open options window -> Formulas -> Set workbook calculation to “Manual”. Now, for your workbook to calc you’ll have to press F9.
1
Senior Manager 1
Remove any formulae that use columns in that table, eg vlookups. There may be ways to optimise the formulae, eg vlookup approx match = false is very slow, or changing the structure a lot, eg using pivot tables and getpivotvalue.
1
Anonymous User
Thank you everyone so it’s on manual calculation now. Does anyone know the difference between manual and automatic calculation? Like how will this affect my work or will it?
Analyst 1
If you are sorting and filtering the data to investigate the raw data, you wouldn’t need to calculate unless you’ve changed calculation columns or any aggregating sheets
Under formulas, there is calculation option. There is a drop down to turn your calcs to manual. Maybe that will stop the threads
Alt m x m
Alt f+t to open options window -> Formulas -> Set workbook calculation to “Manual”. Now, for your workbook to calc you’ll have to press F9.
Remove any formulae that use columns in that table, eg vlookups. There may be ways to optimise the formulae, eg vlookup approx match = false is very slow, or changing the structure a lot, eg using pivot tables and getpivotvalue.
Thank you everyone so it’s on manual calculation now. Does anyone know the difference between manual and automatic calculation? Like how will this affect my work or will it?
If you are sorting and filtering the data to investigate the raw data, you wouldn’t need to calculate unless you’ve changed calculation columns or any aggregating sheets