I have created a spreadsheet that performs calculations using data fromanother spreadsheet. It worked fine inthe past when I only needed to link around 50 cells to another spreadsheet.
Now, I have linked 3000 - 4000 cellsto another spreadsheet so each time when I open it, it takes several minutes tocalculate / update all links.
Is there a more efficient way to link a few thousand of cells to another spreadsheetin order to retrieve data on a daily basis?
Now, I have linked 3000 - 4000 cellsto another spreadsheet so each time when I open it, it takes several minutes tocalculate / update all links.
Is there a more efficient way to link a few thousand of cells to another spreadsheetin order to retrieve data on a daily basis?