Working with external workbooks

[drewbny]

I am working with an external workbook and i have named ranges for external workbooks.


my vlookup formulas in my local workbook are as such: vlookup(a10,fall10,4,false)

Fall 10 is the named range for another file which has the Fall10 information on it.

Is this the most efficient way to write formulas with external workbooks? ALso are there any best practices I should know of in order to get my workbooks which used named ranges from external workbooks to calculate as fast as possible? The external workbook data is so large that I cannot put that info into my internal workbook

 

[drewbny]

Does anyone have any recommendations on working with external workbooks in order to have reports calculate faster? Should I save the external workbook and my destination workbook in the same folder on a network? Also is it better to use index/match vs. vlookup so I can shorten my named range on my lookups?