| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula doesn't update when rows are inserted
I have a formula that is simply adding cells E8:E184. When I insert rows
(begining with E185) and populate those rows with data, the formula doesn't pick these up. In all of my other spreadsheets, the formula automatically updates with the inserted rows, but this one doesn't want to do this. Anyone have any ideas? Thanks, arreferee |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula doesn't update when rows are inserted
Keep cell e184 blank, and insert rows at row 184. Formula will then expand to
include the expanded range. "arreferee" wrote: I have a formula that is simply adding cells E8:E184. When I insert rows (begining with E185) and populate those rows with data, the formula doesn't pick these up. In all of my other spreadsheets, the formula automatically updates with the inserted rows, but this one doesn't want to do this. Anyone have any ideas? Thanks, arreferee |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula doesn't update when rows are inserted
Thanks John...this works. Do you (or anyone else) know why it's not working
currently? I have another formula on the same spreadsheet that works perfectly. Thanks again. "John Lyons" wrote: Keep cell e184 blank, and insert rows at row 184. Formula will then expand to include the expanded range. "arreferee" wrote: I have a formula that is simply adding cells E8:E184. When I insert rows (begining with E185) and populate those rows with data, the formula doesn't pick these up. In all of my other spreadsheets, the formula automatically updates with the inserted rows, but this one doesn't want to do this. Anyone have any ideas? Thanks, arreferee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to fix a formula, so when a row is inserted it doesn't cha | Excel Discussion (Misc queries) | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| apply formula to other rows ... | Excel Discussion (Misc queries) | |||
| If formula result is false, how do I auto-delete that rows? | Excel Worksheet Functions | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Linear Mode
