Formula abruptly changed
Hi,
Can anyone tell me why this happened?
All of my formula cell references moved up a number!
(e.g. 'Sheet3'!$F$3:$F$9999="yyyyy" changed to 'Sheet3'!
$F$4:$F$10000="yyyyy"
All formulas, array entered or not... everything!
What occured:
My workbook is 3 sheets long.
Sheet3 is data only. I updated this from top to bottom
from cut and paste procedure. Row 1 acts as a header, a
blank row2 exists by design then lots of data from row 3
down with lots of columns.
Sheet2 contains my calculations/formulas. Problem rests
here!
Anybody experience this before?
TIA
|