G
Guest
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???
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???