I have a SUMIF formula on one spreadsheet, which is reading information from
another spreadsheet.

On opening my spreadsheet it shows #VALUE in every cell which refers to this
sheet. I have to then open the other spreadsheet to get the results to return.

I have links to other spreadsheets in my main spreadsheet and this doesn't
happen anywhere else...

Any ideas guys???