Financial summary workbook linking all individual financial workbooks. I’m using SUMPRODUCT(link…INDEX(link…MATCH(link….))) to calculate each cells, but #REF! error on the summary workbook unless I open each individual workbooks. Is there a way to overcome the error?
I’ve tried using Xlookup but the same error happens. I believe all these functions are dynamic arrays and unless I write a macros to overcome, otherwise it’s inevitable to open each individual workbooks. Can I get help writing a macros, please?
New contributor
Zora Lee is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.