I have 8 workbooks linked to a master.
If the workbooks are ALL open, it works fine, but once I close them I get #VALUE in all fields. I don't remember having this problem until the last 6 months or so. What can I do to resolve this?
I read somewhere if you are using COUNTIFS that may be the problem ???

HELP !!!!