| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Linear Mode
