countif & sumif applied i do not update if source doc is not open

[Guest]

msoffice 2003. setup a workbook as the source. in a separate (2nd) workbook
setup your functions specifically countif and sumif. with only the source
open - make changes and close. open secondary wbook which is linked with
countif/sumif functions - the functions do not update. you have to click
menu, edit - links - open source which only then updates. even if you change
the setting: menu tools, options, edit remove tick from "Ask to update
automatic links" the linked workbook does not update. I do not want to have
all workbooks open for update from source to occur. Any solutions?

 

[Franz Verga]

msoffice 2003. setup a workbook as the source. in a separate (2nd)
workbook setup your functions specifically countif and sumif. with
only the source open - make changes and close. open secondary wbook
which is linked with countif/sumif functions - the functions do not
update. you have to click menu, edit - links - open source which
only then updates. even if you change the setting: menu tools,
options, edit remove tick from "Ask to update automatic links" the
linked workbook does not update. I do not want to have all workbooks
open for update from source to occur. Any solutions?

Use SUMPRODUCT instead of COUNTIF and SUMIF, because sUMPRODUCT don't need
to have the source workbook opened.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy