Using SUMPRODUCT(link…INDEX(link…MATCH(link….))) but link doesn’t work unless files are open. How to overcome? Can I write a macros?
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?