E
EBets
All - I'm looking for some solutions/suggestions that might help.
I have a excel consolidation file (to get a data table 64000 rows & 10
columns) that is linked using direct links to 16 other files (with dat
tables of 4000 rows & 100 columns).
The problem is the file is a massive 75MB. I still need to buil
additional tables using sumifs & pivots etc as well as graphs into th
consolidation file but as you can imagine the file is painfully slow.
I have already switch off update external links and everything is o
manual calculation.
Any ideas or suggestions?
Thank
I have a excel consolidation file (to get a data table 64000 rows & 10
columns) that is linked using direct links to 16 other files (with dat
tables of 4000 rows & 100 columns).
The problem is the file is a massive 75MB. I still need to buil
additional tables using sumifs & pivots etc as well as graphs into th
consolidation file but as you can imagine the file is painfully slow.
I have already switch off update external links and everything is o
manual calculation.
Any ideas or suggestions?
Thank