Linking 2000+ cells to another spreadsheet

ice_28

New member
Joined
Jul 8, 2011
Messages
5
Reaction score
0
Points
0
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?
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,524
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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...
 
Top