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?
Wow... that sounds like a terrifying situation to me...
Is the original spreadsheet being treated like a database? If your cells were all in a table in the source file, you could pull them in using a PivotTable. I'm fairly certain that would be quicker...
Ken Puls, FCPA, FCMA, MS MVP (Excel)
Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.