Hi,

Am Sun, 8 May 2016 12:17:04 +0100 schrieb GijsKijlstra:

Besides 2016 data in my 2016 workbook, I have there 2015 data for
comparison purposes, with SUMIFS formulas linked to my 2015 workbook.
The 2016 workbook presents the correct 2016 values but return an #VALUE!
message for the 2015 values, when I open the 2016 workbook and the 2015
workbook is closed. (Clicking “ignore links” or “Update” doesn’t solve
the issue). Only when I click “Edit Link” and “Open Source” –
effectively opening the 2015 workbook - I get the correct (2015) data.

use SUMPRODUCT to refer to a closed workbook.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional