Resetting Worksheet formulas

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

What I have is a formula in a worksheet that refers to
another worksheet in the workbook... What I want to do is
use the workbook from month to month... The worksheet
containing the monthly data will be coppied in monthly
from a query workbook that has the formats set up... The
worksheet will always have the same name, "Sample Back-
up"...The Formula is as follows;

=SUMPRODUCT(--(MID('Sample Back-up'!$D$2:$D$500,1,11)
="RHS00222100"),--('Sample Back-up'!$N$2:$N$500))/2

The problem is that when "Sample Back-up" is not part of
the workbook it results is REF, to be expected... When I
copy "Sample Back-up" into the workbook, the formula
still refers to REF... I can go into each formula and hit
enter and it will calculate... I've tried saving,
closing, and opening and it still refers to REF...Is
there a way to recalculate or reset the workbook or
individual sheets...

Thanks in Advance,
Kevin
 
Back
Top