I am in Excel 2010.

I have a template that pulls information from two separate spreadsheets, based on input parameters. One works just fine and will update when teh parameters are changed.

One, however, requires the spreadhseet be open to show correct data. For example, I open the source doc, and get #VALUE errors until i double click on a cell to open the referenced spreadsheet. At that point the data fills.

Any ideas how to get this to work without needing to open the spreadsheet?

Thanks!