I have a sheet that totals the row values when a row is added from a form.  It worked well until the cell containing the formula was linked using vlookup to a separate sheet that is the source of a dashboard.  Now it will not calculate and the sheet that references the cell will not be displayed in the fo