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

Hi
sounds like you have inserted a row before row 3 on the sheet3

--
Regards
Frank Kabel
Frankfurt, Germany

Harry wrote:
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

I deleted row 2 and I returned to 3's in my formula.
I must have added a row but I always had a blank row2 and
still did as I pasted to A3. It worked in any event.
Thank you very much!

-----Original Message-----
Hi
sounds like you have inserted a row before row 3 on the
sheet3

--
Regards
Frank Kabel
Frankfurt, Germany

Harry wrote:
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


.