I have a very large spreadsheet I use for payroll. I currently look up to several seperate sheets using SUMPRODUCT formulas. Most work correctly, but one particular link doesn't work unless I have the other spreadsheet open that I am looking up to.

I am concerned that someone else will not know to do this, and the numbers will be wrong.

Any help is appreciated! Thanks in advance!