Hi all - i have built an XLSM workbook that is not even 100kb in size, yet it is painfully slow to save.
the macros:
- extremely simple - only 5 codes
- the macro is also only just range value =... so nothing fancy
- macro is launched by a command button
the formulas:
- across 4 sheets 80% are probably just xlookups
- i have kept all of the calculations formulas on one sheet to minimise referencing
- there are no unused areas making sheet sizes massive
- there are no external linked sheets
- there are no poorly named ranges in name manager
- the most complex formula is a =TAKE(SORT(FILTER(HSTACK($H$50:$H$172,$C$50:$C$172),($B$50:$B$172='DMS3'!$A$1&" filler")*($D$50:$D$172="shift 1")),1,-1),5) and there are only 4 of these.
it seemed to slow down as i built more and more xlookups on the sheets pointing to the calcs sheet - but in all there is probably still only 40 cells with formulas on each of those sheets.
I have a sheet over 5mb that runs better.
is there something i can look at trying?
other excel sheets appear to run just fine
the macros:
- extremely simple - only 5 codes
- the macro is also only just range value =... so nothing fancy
- macro is launched by a command button
the formulas:
- across 4 sheets 80% are probably just xlookups
- i have kept all of the calculations formulas on one sheet to minimise referencing
- there are no unused areas making sheet sizes massive
- there are no external linked sheets
- there are no poorly named ranges in name manager
- the most complex formula is a =TAKE(SORT(FILTER(HSTACK($H$50:$H$172,$C$50:$C$172),($B$50:$B$172='DMS3'!$A$1&" filler")*($D$50:$D$172="shift 1")),1,-1),5) and there are only 4 of these.
it seemed to slow down as i built more and more xlookups on the sheets pointing to the calcs sheet - but in all there is probably still only 40 cells with formulas on each of those sheets.
I have a sheet over 5mb that runs better.
is there something i can look at trying?
other excel sheets appear to run just fine
